Forum Discussion
Mighty_Al
May 20, 2023Copper Contributor
Multi-word search from text
Hello, I have a data sheet that cotains keywords within its ID and I'm having a difficult time having excel to search for mulitple keywords per cell. I use a combination of IF and SEARCH but it o...
- May 20, 2023
Use
=IFERROR(INDEX({"redo","pass"},MATCH(TRUE,ISNUMBER(SEARCH({"redo","pass"},A2)),0)), 0)
(Note that I used "pass" instead of "passive")
Even better: replace {"redo", "pass"} with a range that contains the keywords. Much easier to maintain!
HansVogelaar
MVP
Use
=IFERROR(INDEX({"redo","pass"},MATCH(TRUE,ISNUMBER(SEARCH({"redo","pass"},A2)),0)), 0)
(Note that I used "pass" instead of "passive")
Even better: replace {"redo", "pass"} with a range that contains the keywords. Much easier to maintain!
Mighty_Al
May 20, 2023Copper Contributor
thank you!