Double Index Match

I am attempting to pull the same data from two separate sheets. The formula for the single index match is as follows and works perfectly.

=INDEX({Outlook or Estimated Install Date}, MATCH(Key@row, {Jira Tracking ID}, 0))

The column names for 2 different sheets in which I would like to pull the result from are the same "Outlook or Estimated Install Date". One comes from Country Plan 1 and the other comes from Country Plan 2. The match columns in both of these sheets are named the same too "Jira Tracking ID"

Can you use an index match to achieve this?

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @GillianMcGovern

You can add two formulas looking at two different sheets together, so you can output both results into one cell.

=INDEX(MATCH()) + ", " + INDEX(MATCH())

For example:

=INDEX({Outlook or Estimated Install Date Sheet 1}, MATCH(Key@row, {Jira Tracking ID Sheet 1}, 0)) + ", " + INDEX({Outlook or Estimated Install Date Sheet 2}, MATCH(Key@row, {Jira Tracking ID Sheet 2}, 0))

Let me know if this is what you were looking to do!

Cheers,

Genevieve

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.