Link to home
Create AccountLog in
Avatar of Tom Fullen
Tom FullenFlag for United States of America

asked on

Culling a emailing list in Excell 2003

Hello,

I have a emailing list (List A) in Excel 2003 that has a number of addresses that Bounce.

I also have another list (List B) that contains all the addresses that have bounced.

How can I remove the addressed in List B from List A using Excel 2003.

Or is there a better program for this?

Thanks in advance,
Tom Fullen
ASKER CERTIFIED SOLUTION
Avatar of gnazareth
gnazareth
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Tom Fullen

ASKER

Thank you, gnazareth,

How do you add the formula to all the cells in the column so that the A2, A3, A4, are added automatically, and I won't have to type into every cell?

Tom
The formula  is not excepted seems to be something wrong with the table array?

=IFERROR(VLOOKUP(A2,Sheet1!$A$1:$B$4,2,FALSE),"DO NOT REMOVE")