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!

Find more posts tagged with

Formulas

functionality

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.