Index Match with multiple sheet references Help.

I am trying to use the index/match function across multiple reference sheets.

(Formula #1 works but just across on reference sheet) =INDEX({Team X Email list}, MATCH([Five9 ID]@row, {Team X Five9 Username}, 0))

(Formula #2 does not work across multiple reference sheets) =INDEX({Team X Email list}, MATCH([Five9 ID]@row, {Team X Username}, 0)), INDEX({Team Y Email list}, MATCH([Five9 ID]@row,{Team Y Five9 Username},0))

I am getting an unparseable error.

Please help.

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Yes. You would just keep adding IFERRORs.

=IFERROR(IFERROR(1st index match, 2nd index match), 3rd index match)

All comments

Victoria_Indimar

Hi Mike. What are you expecting as the output? It looks like you just have it listed twice in the same formula =Index, Index. Are you trying to do the index match to pull two separate values from two difference sheets but populate the one field?

Mike Deeeez

The goal is to populate the associate's email address. We have associates who move teams, so in order to find the associate's email address, I would need to find the match from the team page that it currently exists.

Formula #1 is an example of finding that associate's email address on their current team, but if they moved to a different team page, the value would turn out NO MATCH.

Paul Newcome

@Mike Deeeez You need to incorporate an IFERROR. The logic is that if it isn't found on the first sheet, it will throw an error, so you use the IFERROR to tell it to evaluate the second sheet.

=IFERROR(1st index match, 2nd index match)

Mike Deeeez

Thank you that worked, but when adding a third, fourth, and so on sheets, I am getting an incorrect argument set message.

Mike Deeeez

@Paul Newcome Can you use IFERROR for more than 2 sheets. I incorporated it with just 2 sheets but not for more than 2. Thanks for your help.

Paul Newcome

Yes. You would just keep adding IFERRORs.

=IFERROR(IFERROR(1st index match, 2nd index match), 3rd index match)

Mike Deeeez

@Paul Newcome I appreciate your help.. That worked!!

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