IFERROR Not Returning the Correct Message

Hammermill21

Hello!

I am using an IFERROR with Index/Match and it will not return the error message of "Pending" as I am requesting in the formula, it just shows blank. I'm not sure why:

=IFERROR(INDEX({Data Dump || Pre-Hurricane - iFormBuilder Range 2}, MATCH([Building Name]@row, {Data Dump || Pre-Hurricane - iFormBuilder Range 1}, 0)), "Pending")

The formula works just fine, I just need it to show Pending when there is no match and it won't, the cell just stays blank.

Any ideas?

Thank you!

Paul Newcome

That's because it is matching on something in range 1 and the corresponding row in range 2 is blank.

Hammermill21

Hey Paul,

I'm not so sure, because it works sometimes and other times it's not:

Paul Newcome

Check your source sheet for "6500 Red D".