Forum Discussion
Solved
IFS and SEARCH with three different return values
Hi! A newbie on this forum and would never consider my self as an Excel expert 🙂 Plus I'm not very used to the IFSand SEARCH formulas, so I hope you guys out there might help me. Got a list ...
For example:
=IFS(ISNUMBER(SEARCH("Advantage";A16));"Advantage";ISNUMBER(SEARCH("Essential";A16));"Essential";ISNUMBER(SEARCH("Premier";A16));"Premier";TRUE;"")
Alternatively:
=IFERROR(LOOKUP(1000;SEARCH({"Advantage";"Essential";"Premier"};A16);{"Advantage";"Essential";"Premier"});"")
or
=TEXTJOIN("";TRUE;IF(ISNUMBER(SEARCH({"Advantage";"Essential";"Premier"};A16));{"Advantage";"Essential";"Premier"};""))