Vlookup - Comparing two lists in different worksheets

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

[Morrigan]

A simple MATCH() function can do it or:

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


Hope this helps.

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.

[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","")

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

[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

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