Try this regular formula, copied down
An alternative is to put your list of words in a range:![]()
E2: =IFERROR(INDEX({"plat";"orig"},MATCH(1,INDEX(COUNTIF(B2,{"*plat*";"*orig*"}),0),0)),"")
I1:I2 contains
plat
orig
Then you could use this regular formula
Is that something you can work with?![]()
E2: =IFERROR(INDEX($I$1:$I$2,MATCH(1,INDEX(COUNTIF(B2,"*"&$I$1:$I$2&"*"),0),0)),"")
Bookmarks