Hi All,
I got a question about how I can achieve the similar output of an excel to "iferror(vlookup(a1,[vlookup table],1,0),"N").
Sample data as follows :-
a. List of 6 invoices
| Invoice |
| 22009969 |
| 22009965 |
| 22009977 |
| 22009952 |
| 22009985 |
| 22009963 |
b. vlookup to list of 3 invoices
| Invoice | Offset |
| 22009965 | Y |
| 22009952 | Y |
| 22009985 | Y |
c. expected results
| Invoice | Offset |
| 22009969 | N |
| 22009965 | Y |
| 22009977 | N |
| 22009952 | Y |
| 22009985 | Y |
| 22009963 | N |
I tried join but it will only return me with 3 invoices. Any insights to how to achieve that will be appreciated!
