Search particular word in a phrase

[Bong9178]

Hi Experts

I am trying to look for a formula to use to do the following function:

1. In a given column to search for a specific words (17 in total)
2. Once identified it need to return specific value

[#2]

I tried to use this formula i found in one of the groups but it only limits me to two sets of text i need to search and identify 17 text in a column and once match need to return to s specific text =IFERROR(IF(SEARCH("*Sales*",B3,1),"Sales"),IF(SEARCH("*Arch*",B3,1),"Architecture"))

[#3]

@Bong9178 

It's better to place what to search and what to return if found in separate helper range like

(expanding on all 17 values)

Formula in C1 could be like

=IFERROR(INDEX($G$1:$G$5,MATCH(1,INDEX(--ISNUMBER(SEARCH("*"&$F$1:$F$5&"*",$B1)),0),0)),"no such")

and drag it down