Forum Discussion
IFS with wildcards
I am attempting to extract a word, preferably wildcard style from a cell and then place the desired text in another cell. This is the formula that works for a specific word =IFS(A12="smoke","Smoke D...
Amazing, worked well. Thanks so much.
As variant
=IFERROR(
CHOOSE(COUNTIFS(A12,"*smoke*")+2*COUNTIFS(A12,"*heat*")+3*COUNTIFS(A12,"*pull*"),
"Smoke Detector","Heat Detector","Pull Station"),
"no such")