IF , MATCH problems with formula

[treeroot]

I have a worksheet that I am using on the first sheet "high priority"
A3:A5764.. I have my master contact list. on the second sheet "bouncebacks"
A1:A1199.. I have bounced back emails. I am trying to pull all of the
bounced back emails off of the high priority sheet. so I need a formula that
will take the bouncebacks and compare it to my column a in my high priority
sheet and then put bad in column b of the high priority sheet where there is
a bouncedbackemail. this is what I am working with now. it is returning
good and bad in column b if I paste the fomula in each indivual cell but the
ones that are coming back bad shouldn't be bad they aren't on the bounceback
list.
thanks in advance
=IF(ISNA(MATCH(A3,bouncebacks!$A$1:$A$1199,0)),"good","bad")

 

[ShaneDevenshire]

Hi,

Many ways, here's one:

In cell B1 on the first sheet enter
=COUNTIF(A1,bouncebacks!AS1:AS1199)

If you want you can just enter this, if the result is >0 you have a bounce
back. If you want the message then

=IF(COUNTIF(A1,bouncebacks!AS1:AS1199)>0,"bad","good")

The countif function if faster than MATCH or VLOOKUP.