Excel compare columns

I have two columns with a list of email addresses, A and B

How can I do a compare to see if each address in column A is in column B, so print out in column C something like "Found" or Not Found", I'm guessing I can use vlookup but get errors on the ones that are not found, so need a IF or something.

Thanks,
bt707Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=if(isna(vlookup(.....)),"Not found","Found")
0
 
bt707Author Commented:
Thanks for the quick help!!
0
 
Saqib Husain, SyedEngineerCommented:
or maybe

=if(isna(vlookup(.....)),"Not found",vlookup(.....))
0
 
Saqib Husain, SyedEngineerCommented:
Thanks for the quick grading
0
 
JoeNuvoCommented:
error?
do you mean #NA ?

if that is a case, uses something like

=IF(ISNA(VLookup(.....)) , VLookup(.....), "not found")
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.