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

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

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.