Looking for a formula that would return a certain value if found within a group

[MLem50]

I have created a worksheet form with validation drop downs on sheet 1 and I have a data list for the drop downs on sheet 2. The data list includes a list of all employees in column A and employees with a special certification in column B. What I am looking for is that when someone chooses from the list of employees in column A on the form and that employee is also on column b that a value of Yes for true and No for false would appear. I have tried several If and Search formulas but cannot seem to get it to work correctly. THANKS

[MrShorty]

If your "dropdown" list is in A1, a COUNTIF(B:B,A1) should tell you how many instances of A1 is in column B. If this count is 0, then the name in A1 is not there, if this count is 1 or more, then the name is present in B.

[oeldere]

Since you not add a small excel file, I can't show you, but you can do this with VLookup.