Try this: =INDEX($A$3:$A$7,MATCH("*"&D3&"*",$B$3:$B$7,0))