Great tips - I was on the microsoft site for over an hour trying to figure it out, took me 5 minutes with this tip. Thanks!
Great tips - I was on the microsoft site for over an hour trying to figure it out, took me 5 minutes with this tip. Thanks!
Problem:
Column B contains values to look up in List1 (Column A).
We want to modify the results returned by the VLOOKUP function to include the lookup term as well as an indication of whether or not the value was found.
Solution:
Use the IF, ISNA, and VLOOKUP functions as shown in the following formula:
=IF(ISNA(VLOOKUP(B2,$A$2:$A$7,1,FALSE)),B2&\"Not Found\",VLOOKUP(B2,$A$2:$A$7,1,FALSE)&\"Found\")
Worked well. Thanks a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks