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?
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.
