IFERROR Not Returning the Correct Message

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!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!