iferror(vlookup...) replacement

[SArielle]

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!

[FrederikE]

Hey @SArielle,

This should achive it: 

[RSreeSurya · Accepted solution]

Hi,

Attaching the sample workflow.

Output of the Workflow:

[Qiu · Accepted solution]

@SArielle 
A Find and Replace Tool can do work also.