good am. Welcome to the forum..
can you try this one.

=INDEX(A:A,MATCH("*"&D1&"*",B:B,0))

you're on excel 2010

you can use.

=iferror(INDEX(A:A,MATCH("*"&D1&"*",B:B,0)),"")