Nested IF-MATCH

[arfabe16]

Hello, I'm trying to create a single column that populates cells based on a unique identifier that can be matched to either column A or column B in a different sheet, but I can't get it to work.

When I create my formula for just column A or column B, they work:
=IF(MATCH(F2,'Hot Alert IDs'!$A:$A,0),"Dissatisfied",) works independently
=IF(MATCH(F2,'Hot Alert IDs'!$B:$B,0),"No Contact",) also works independently

But when I try to combine them, I can't get it to work; the column only populates for the first IF-MATCH function. This is what I have:
=IF(MATCH(F2,'Hot Alert IDs'!$A:$A,0),"Dissatisfied",IF(MATCH(F2,'Hot Alert IDs'!$B:$B,0),"No Contact",))

What am I doing wrong? Any help would be greatly appreciated!!!

 

[mrshl9898]

Try

=IFERROR(IF(MATCH(F2,'Hot Alert IDs'!$A:$A,0),"Dissatisfied",),IF(MATCH(F2,'Hot Alert IDs'!$B:$B,0),"No Contact",))

The challenge is if the first MATCH fails it is not false, but an error.

 

[mrshl9898]

You may even want a second IFERROR if no MATCH is found in either column.

=IFERROR(IFERROR(IF(MATCH(F2,'Hot Alert IDs'!$A:$A,0),"Dissatisfied",),IF(MATCH(F2,'Hot Alert IDs'!$B:$B,0),"No Contact",)),"")

 

[arfabe16]

You may even want a second IFERROR if no MATCH is found in either column.

=IFERROR(IFERROR(IF(MATCH(F2,'Hot Alert IDs'!$A:$A,0),"Dissatisfied",),IF(MATCH(F2,'Hot Alert IDs'!$B:$B,0),"No Contact",)),"")

That did it. Thanks!

So, I'm assuming my issue is that, when Excel encounters an error, it essentially stops running my formula -- correct?

 

[mrshl9898]

Correct