quick countif or index/match or vlookup formula

[banneduser123]

This may be simple, but can't figure out how to write this up yet...any help is appreciated

if column B matches column A exactly, then check if column D is contained somewhere in column E. If so, return Yes

 

[Fluff]

In that case how do you know

it's telling me "Germany" is in a cell that says "Not Applicable"

It's simply checking the whole of column E for the word & doesn't return a specific cell