Solved Excel if and vlookup

November 9, 2012 at 01:41:55
Specs: Windows 7
Hi i'm in need of a code for excel that can look in a cell and compair the word in the cell with a list of words if the value is found in the list it should return blank. is this possible?

See More: Excel if and vlookup

Report •

November 9, 2012 at 07:20:52
✔ Best Answer
You've told us that you want a blank cell if the word is found in a list, but you haven't told us what you want if the word is not found in the list.

This formula will return a blank if found, "Not Found" if not:

=IF(ISNA(MATCH(A1,$B$1:$B$5,0)),"Not found","")

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question