IF , MATCH problems with formula
 

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)),"go od","bad")

IF , MATCH problems with formula
 

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

The countif function if faster than MATCH or VLOOKUP.
--
Thanks,
Shane Devenshire


"treeroot" wrote:

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)),"go od","bad")