I use the formula shown below frequently to eliminate the #N/A from the return of a VLOOKUP.
In addition, I would like to specify what result is returned from the lookup.
Basically, instead of retrieving the value that is found in the cell (e.g. a product number) I would simply like to display something like "found" or "x", etc.
As always, any insight is GREATLY appreciated!
In addition, I would like to specify what result is returned from the lookup.
Basically, instead of retrieving the value that is found in the cell (e.g. a product number) I would simply like to display something like "found" or "x", etc.
As always, any insight is GREATLY appreciated!
Code:
=IF(ISNA(VLOOKUP(A2,'Tab 1'!A:B,1,FALSE)),"",(VLOOKUP(A2,'Tab 1'!A:B,1,FALSE)))