Forum Discussion
Solved
Need to find multiple search terms within my spreadsheet
Hello, I would like to write a code to find if any terms from my list (typed in column B) are found in column A. Column A Susan Prair Chalk Railroad Troublsom Waters Liszet...
This may work for you. SEARCH is not used because of the potential for false positives (e.g. "USA" would be found in "Susan", etc.).
=IF(SUM(IFERROR(FIND(terms,A2),0))<>0,"A term is present","")
Using the Match function might work. But it will do it one after another. It has to be something that can be automated
Better still use pivot table