VLOOKUP - IF Statement - Column Compare - YES or NO result desired

Last question was answered so quickly & accurately, I figured I'd give it another go!

So in Column A, there's a list of Magazine names. In Column C there's a list of Advertiser's names. Magazine titles & Advertiser names may repeat like so...

Time Magazine (Column A) ........ Amazon (Column C)
Time Magazine (Column A) ........ Amazon (Column C)
Forbes (Column A) ........ Google (Column C)
Forbes (Column A) ........ Amazon (Column C)

On a separate sheet in cell A1 I have a Data Validation drop down with the names of Advertiser's from Column C mentioned before.

I'm looking to input a formula which will lookup the Advertiser's name selected by the data validation drop down & tell me YES or NO to whether their name is ever associated with a specific magazine title in Column A, such as Forbes.

So in the example above, I'd want to be able to select the Advertiser "Google" from my data validation drop down & see a YES, indicating to me they do advertise in Forbes.

Hopefully this makes sense!