Have a look at VLOOKUP
More details in morning

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"calberto22" wrote in message
ups.com...
Guys, i'm completely stuck on this and hoping you can help. i have 2
columns with emails. i need to compare column B to Column A. if an
email that is in column B is also in column A, then i don't need it.
but if it's unique to column B (it's not in column A as well) then i
need that email. i can't for the life of me figure out how to do
this. i was doing an IF function, but it's not working. i was doing
this =IF(B2=A1:A443, 'NO', B2). so basically, if the email in cell B2
is found in the range A1 to A443, then type NO, if the email in B2 is
NOT found, then give me the email that is in B2. this function is not
working though. can you help me out?

Thank you

Carla