Problem:

column1 of worksheet1 contains a list of bad email addresses


column1 of worksheet2 contains a list of all email addresses on file


i need to compare the list of bad addresses (worksheet1) to the list of

all email addresses (worksheet2) and if there is an email address in
the bad list (worksheet1) which is also in the all emails
list(worksheet2), i need to flag it by putting "bad" in the next column

of the all addresses list (worksheet2).


i've been looking through this forum for the past few days and can't
seem to find something that can do this. it looks like it should be
simple but i've had no luck. any help would be appreciated.


p.s. the all email address list (worksheet2) can be quite long...around

8000 rows.


Rich