Solved

Excel compare columns

Posted on 2011-03-24
5
311 Views
Last Modified: 2012-05-11
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,
0
Comment
Question by:bt707
  • 3
5 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 35207145
=if(isna(vlookup(.....)),"Not found","Found")
0
 

Author Closing Comment

by:bt707
ID: 35207151
Thanks for the quick help!!
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35207155
or maybe

=if(isna(vlookup(.....)),"Not found",vlookup(.....))
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 35207158
Thanks for the quick grading
0
 
LVL 11

Expert Comment

by:JoeNuvo
ID: 35207187
error?
do you mean #NA ?

if that is a case, uses something like

=IF(ISNA(VLookup(.....)) , VLookup(.....), "not found")
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question