Forum Discussion

Mighty_Al's avatar
Mighty_Al
Copper Contributor
May 20, 2023

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...
  • HansVogelaar's avatar
    May 20, 2023

    Mighty_Al 

    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!

Resources