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