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!
Solved! Go to Solution.
@SArielle
A Find and Replace Tool can do work also.