I am working on a search to look for words found in 1 cell using formula
=IF(OR(ISNUMBER(SEARCH("WORD1",A1,1)),ISNUMBER(SEARCH("WORD2",A1,1)),ISNUMBER(SEARCH("WORD3",A1,1))),"","FOUND")
there is about 20 word seaches and i was wondering if i put them in a column is there a way to seach the column to find any of the words with it and respond if found
some thing like
=IF(ISNUMBER(SEARCH($B$2:$B$21,A1,1)),"","FOUND")
I am using excel 2003 and have not been able to get it to work how i want it to
thanks for the help -David
Bookmarks