I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail addresses.
I want to create a list of those that are in list 1 that are not in list 2. I
amusing this:
=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")

My problem is that =A1 does not list the e-mail address in cell one it just
shows up at =A1. How can I get the value in A1 to show up?

Thanks

On Aug 18, 3:32 pm, DAA <D...@discussions.microsoft.com> wrote:
> I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail addresses.
> I want to create a list of those that are in list 1 that are not in list 2. I
> amusing this:
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>
> My problem is that =A1 does not list the e-mail address in cell one it just
> shows up at =A1. How can I get the value in A1 to show up?
>
> Thanks

=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),A1,"")

>=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")

Remove the quotes and = sign:

=IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),A1,"")


--
Biff
Microsoft Excel MVP


"DAA" <(E-Mail Removed)> wrote in message
news:0BD28A70-4D2A-45FE-B4CC-(E-Mail Removed)...
>I have list 1 with 169 e-mail addresses and list 2 with 645 e-mail
>addresses.
> I want to create a list of those that are in list 1 that are not in list
> 2. I
> amusing this:
> =IF(ISERROR(VLOOKUP(A1,$C$1:$C$814,1,FALSE)),"=A1","")
>
> My problem is that =A1 does not list the e-mail address in cell one it
> just
> shows up at =A1. How can I get the value in A1 to show up?
>
> Thanks