Forum Discussion
Need to search multiple words in a cell and get the output based on the word found.
If you have Excel 2019 or Excel in Microsoft 365, enter the following formula in B1:
=TEXTJOIN(", ",TRUE,IF(ISNUMBER(SEARCH({"Generic Mailbox","Distribution","Non-standard","NSSR"},A1)),{"Shared Mailbox","DL","Corporate Request","Non-Standard Service Request"},""))
This allows for more than one of the search terms in a cell.
Otherwise:
=IFERROR(INDEX({"Shared Mailbox","DL","Corporate Request","Non-Standard Service Request"},MATCH(TRUE,ISNUMBER(SEARCH({"Generic Mailbox","Distribution","Non-standard","NSSR"},A1)),0)),"")
Fill down from B1.
Like this:
=IF(ISNUMBER(SEARCH("[INTERN]",A2)),IF(ISNUMBER(SEARCH("Offensive",A2)),"INTERN Offensive","INTERN"),IF(ISNUMBER(SEARCH("Offensive",A2)),"Offensive","Regular"))
It is indeed a great tool this Excel in the hands of someone who knows how to use it.
Many greetings from Romania.
You're welcome (greetings from The Netherlands)