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.

A simple MATCH() function can do it or:

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


Hope this helps.


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.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=393948

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.

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.