Return blank cell for formula is there's a match in a column?

**djarcadian** · 02-18-2015, 10:36 AM

I use the following formula to check for an email address in a column and return a blank cell if there's a match.

=IFERROR(IF(COUNTIF(DoNotEmail!A:A,A3),"",VLOOKUP(A3,AccountList!$A$1:$AA$1003195,16,FALSE)),"")

I want to apply the same filter to this formula:

=INDEX(AccountList!P:P,MATCH(A3,AccountList!A:A,0))

I tried doing this:

=IFERROR(IF(COUNTIF(DoNotEmail!A:A,A3),"",INDEX(AccountList!P:P,MATCH(A3,AccountList!A:A,0)),"")

but it doesn't seem to work. Is there something wrong in that formula?

**Pete_UK** · 02-18-2015, 10:47 AM

I think you have a missing close-bracket - try this:

=IFERROR(IF(COUNTIF(DoNotEmail!A:A,A3),"",INDEX(AccountList!P:P,MATCH(A3,AccountList!A:A,0))),"")

Hope this helps.

Pete

**Special-K** · 02-18-2015, 10:49 AM

Oops! Error on my part, pls ignore

**djarcadian** · 02-18-2015, 10:54 AM

Originally Posted by Pete_UK

I think you have a missing close-bracket - try this:

=IFERROR(IF(COUNTIF(DoNotEmail!A:A,A3),"",INDEX(AccountList!P:P,MATCH(A3,AccountList!A:A,0))),"")

Hope this helps.

Pete

Yeah, I think that was it. I also removed the IFERROR since I really didn't need it in this case.

=IF(COUNTIF(DoNotEmail!A:A,A3),"",INDEX(AccountList!P:P,MATCH(A3,AccountList!A:A,0)))