Please try at F4
=VLOOKUP("*"&E4,$B$4:$C$9,2,FALSE)

But better approach is to clean data from Column B.