Find partial text string within another text string return original text into cell.

Try this in B2 and filled down

=IFERROR(LOOKUP(2^15,SEARCH($C$2:$C$32,A2),$C$2:$C$32),"")

Note, there cannot be any blanks in C2:C32

Originally Posted by Jonmo1

Try this in B2 and filled down

=IFERROR(LOOKUP(2^15,SEARCH($C$2:$C$32,A2),$C$2:$C$32),"")

Note, there cannot be any blanks in C2:C32

This worked but when i upgraded the C column to include more variables some of the results came back as just the word Golf which i highlighted in green in this sheet.