How to compare two different email lists in excel to find overlap

[jesperb]

We send out a newsletter and I'd like to find out how the recipients of the newsletter overlap with our customer lists - to find out how many who receive the newsletter have never become customers.

In Column A, I have a list of all newsletter subscribers and in Column B I have a list of all of our customers.

How do I in column C, get a list of all the newsletter subscribers who are in column A, but are not in column B?
I've tried filtering and conditional formating, but that didn't seem to be the right way.

I'm using Excel 2008 for Mac.

I'm pretty sure there must be a simple way to solve this, but I'm pretty new to Excel, so any help would be much appreciated.

 

[SteveO59L]

something along the lines of

=vlookup(a1,b:b,1,false)

 

[jesperb]

I can't get that to work, when I try to type that exact formula I get the message that "the formula you typed contains an error"

Any idea on what I could be doing wrong?
Also the customer list is about 20% longer than the newsletter subscription list, and they aren't sorted in any particular order in case that makes a difference?

 

[SteveO59L]

Slight mod

=IF(ISERROR(VLOOKUP(B1,A:A,1,FALSE)),"Does Not Exist","Exists")

 

[jesperb]

Thank you, however I still get the "the formula you typed contains an error" message when trying to do this, so I'm not sure what is causing these errors.

Could it be because I'm copying your suggestion directly or do you think it could be related to using the Mac version of Excel?

 

[SteveO59L]

This must be a difference in syntax between windows & mac versions of Excel

Have a look in the help and check the syntax for vlookup()