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,"" )