Return matching string in array if cell contains string contained in the array

Originally Posted by bebo021999

May be in B1:

=IF(SUMPRODUCT(--ISNUMBER(SEARCH($C$1:$C$3,A1)))=0,"",INDEX($C$1:$C$3,MAX(ISNUMBER(SEARCH($C$1:$C$3,A1))*ROW($C$1:$C$3))))

Confirmed with Ctrl-shift-enter

This works great, bebo! I just changed the "" to A1 to display the original string. Thank you!