Displaying value from two lists

  • Thread starter Thread starter DAA
  • Start date Start date
D

DAA

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
 
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
Click to expand...

=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,"")
 
Back
Top