Looking for PART of a cell, in another column and return corresponding value

Hi,

in D2 and below you could try:

Formula:

=IF(ISERROR(INDEX(Data!$C$1:$C$3,MATCH(1,INDEX(SEARCH("*"&Data!$B$1:$B$3&"*",C2),),0))),"",INDEX(Data!$C$1:$C$3,MATCH(1,INDEX(SEARCH("*"&Data!$B$1:$B$3&"*",C2),),0)))

Regards