Jul 24 2019 05:07 PM
Jul 24 2019 05:14 PM
Jul 25 2019 06:21 AM
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