No Match...but the formula works

Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet…

This is the formula:

=IFERROR(IFERROR(IFERROR(INDEX({IQA Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {IQA Log IQA Ref No}, 1)), INDEX({Daily Quality Inspections Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {Daily Quality Inspections IQA Ref No}, 1))), INDEX({Re-Make Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {Re-Make Log IQA Ref No}, 1))), INDEX({CNC Mistakes Log Record Closed?}, MATCH([Primary Column - IQA Ref]@row, {CNC Mistakes Log IQA Ref No}, 1)))

The sheet and range in question is the "Daily Quality Inspections ***"

Any help would be appreciated!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

All the 1s that you have in the third portion of each MATCH function should be 0s.

All comments

Paul Newcome

All the 1s that you have in the third portion of each MATCH function should be 0s.

H.Woods

Huh, so simple and it fixed it! thank you!

Paul Newcome

Happy to help. 👍️

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.