I have two columns -
Column A is a list of company names for folks who took training
Column B is a list of preferred companies

I want to find out if the companies in column A are on the Preferred list.

All I can think of is If the company name in column A is found in Column B -
then say Yes.

I don't even care about the no's!

Can you help?