Link to home
Create AccountLog in
Avatar of cansevin
cansevin

asked on

Find an name in excel

In Column C I have a huge long list of about 22 names. On Sheet 2 Column C I have another list of 50 names. On the first sheet in column D, I would like the cell to say "Yes" If the name on the first sheet is also in the list of the 2nd sheet. If the name isn't in the 2nd sheet the result should be "no". Any idea?
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of cansevin
cansevin

ASKER

Thanks!