index match crossheet

i have sheet A that will look at sheets Q1,Q2,Q3,Q4 TO CONFIRM IF THERE IS A MATCH. and if not to return no match

=IFERROR(IFERROR(IFERROR(IFERROR(INDEX({Q1 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q1 INV 2022 Range 1}, 0)), INDEX({Q2 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q2 INV 2022 Range 1}, 0))), INDEX({Q3 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q3 INV 2022 Range 1}, 0))), INDEX({Q4 INV 2022 Range 1}, MATCH([dupe ids]@row, {Q4 INV 2022 Range 1}, 0))))

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Are you getting an error or an unexpected output?

Bobby1

@Paul Newcome

yes

Paul Newcome

It looks like each INDEX function has the same range as the MATCH function within it?

Bobby1

yes but referenceing different sheets with the ssame naming convention

Paul Newcome

Ah. I see the issue causing the error now. You aren't specifying an output for the final IFERROR.

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.