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","")
OliverScheurich SergeiBaklan Hello, I saw you were able to solve a similar problem. Was wondering if you would be able to look at this. Thank you very much if you are able to solve this problem 🙂
- 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
