Displaying value from two lists
 

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

Displaying value from two lists
 

On Aug 18, 3:32 pm, DAA 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,"" )

Displaying value from two lists
 

=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" wrote in message
...
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

Displaying value from two lists
 

Thank you so much, that worked perfect.

"T. Valko" wrote:

=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" wrote in message
...
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

Displaying value from two lists
 

Thank you.

"Spiky" wrote:

On Aug 18, 3:32 pm, DAA 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,"" )

Displaying value from two lists
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DAA" wrote in message
...
Thank you so much, that worked perfect.

"T. Valko" wrote:

=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" wrote in message
...
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