Vlookup - Comparing two lists in different worksheets

L

Lozby

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.
 
M

Morrigan

A simple MATCH() function can do it or:

=IF(MATCH()>0,"Match found"."No match")


Hope this helps.
 
D

dtbill21

I assume you meant Worksheet B, Column A contains the data after changes, in
that case a formula like so would work:

IF(ISERROR(VLOOKUP(A1,'Worksheet B'!$A$1:$A$300,1,0)),"change made","")
 
L

Lozby

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
 
Top