» Altering the results returned by VLOOKUP.
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?
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
Green_____White_______________White Not Found
Black_____Purple______________Purple Not Found
|Screenshot // Altering the results returned by VLOOKUP. |