Problem:
Column B contains values to look up in List1 (Column A).
How could we alter the results returned by the VLOOKUP function so that they will include the original value looked up and a ""Found""/""Not Found"" indication?
Solution:
Use the ISNA and VLOOKUP functions in an IF statement, as follows:
=IF(ISNA(VLOOKUP(B2,$A$2:$A$7,1,FALSE)),B2&"" Not Found"",VLOOKUP(B2,$A$2:$A$7,1,FALSE)&"" Found"")
List1_____Values to look______Result
Blue______Pink________________Pink Not Found
Red_______Blue________________Blue Found
Green_____White_______________White Not Found
Black_____Purple______________Purple Not Found
Yellow____Red_________________Red Found
Orange
Screenshot // Altering the results returned by VLOOKUP.
Altering the results returned by VLOOKUP.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
