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