Hi to both of you that replied, I had a play round with both the formulas you
sent and couldnt get them to work as matching email addresses on worksheet A
& Worksheet B werent in the same row on the two worksheets (on worksheet B -
some email addresses had been removed from Worksheet B as the email owners
had unsubscribed from my list!)....

I figured out how to use vlookup by adding the word MATCH into Column B on
worksheet B and putting the following formula in Column B on Worksheet A...

=VLOOKUP(A1,B!A:B,2,FALSE)

Cheers for your help - much appreciated

"Lozby" wrote:

Hi

I have 2 lists of unique email addresses. Worksheet A, column A contains the
data before any changes. Worksheet A, Column A contains the data after
changes (email addresses will only have been removed)

Can anyone let me know how I can set up a vlookup formula to show in
Worksheet A which emails are not included in Worksheet B.

I know this is quite simple to do as I have done it before, but I cant
rememebr how to do it !!

Any help appreciated.