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?


  • Genevieve P.
    Genevieve P. Employee Admin

    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!