How to create an Index Match Formula for multiple sheets?

Hi,

I am currently trying to create an Index Match function which will be able to search multiple sheets (5 to 6 separate sheets) for the correct information.

The destination sheet has two columns that it will look at.

A "TIDC" column where staff members place a ticket code
An "Assigned to" column, which is a contact list column

If I were just looking at one sheet the formula would look something like:

=INDEX({Sheet1 Assigned To},MATCH(TIDC@row,{Sheet1 TIDC},0))

I have tried to stack IFERRORs as well as nest IF formulas but it does not seem to function properly.

Any help would be very much appreciated.

Thank you,

Nicholas

Find more posts tagged with

Sheets

Formulas

functionality

Accepted answers

Paul Newcome

Stacking IFERRORS would look like this:

=IFERROR(IFERROR(IFERROR(INDEX({Sheet1 Assigned To},MATCH(TIDC@row,{Sheet1 TIDC},0)), INDEX({Sheet2 Assigned To},MATCH(TIDC@row,{Sheet2 TIDC},0))), INDEX({Sheet3 Assigned To},MATCH(TIDC@row,{Sheet3 TIDC},0))), INDEX({Sheet4 Assigned To},MATCH(TIDC@row,{Sheet4 TIDC},0)))

All comments

Paul Newcome

Stacking IFERRORS would look like this:

nlarson_PMC

Thank you @Paul Newcome !

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.