Forum Discussion

WendyJV's avatar
WendyJV
Copper Contributor
Feb 04, 2026
Solved

INDEX MATCH with VLOOKUP

This is my first time posting here, as I hit a roadblock that I'm sure is simple enough.  I am using the following formula, but the source data ('FY26 Income Statement Data'!$A$4:$A$2158) has several...
excel
Formulas and Functions
  • Olufemi7's avatar
    Olufemi7
    Feb 10, 2026

    Hello WendyJV​, 

    Use SUMIFS instead of INDEX/MATCH to handle multiple matches:

     

    =SUMIFS(INDEX('FY26 Income Statement Data'!$A$4:$AB$2158,0,MATCH(C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0)),'FY26 Income Statement Data'!$A$4:$A$2158,$A7)

     

    Explanation:

    - MATCH(C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0) finds the correct column.

    - INDEX(...,0,...) returns the entire column for that header.

    - SUMIFS sums all rows where Column A equals $A7.

     

Olufemi7's avatar
Olufemi7
Iron Contributor
Feb 10, 2026

Hello WendyJV​, 

Use SUMIFS instead of INDEX/MATCH to handle multiple matches:

 

=SUMIFS(INDEX('FY26 Income Statement Data'!$A$4:$AB$2158,0,MATCH(C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0)),'FY26 Income Statement Data'!$A$4:$A$2158,$A7)

 

Explanation:

- MATCH(C$1,'FY26 Income Statement Data'!$A$4:$AB$4,0) finds the correct column.

- INDEX(...,0,...) returns the entire column for that header.

- SUMIFS sums all rows where Column A equals $A7.

 

WendyJV's avatar
WendyJV
Copper Contributor
Feb 10, 2026

Amazing! That was it :)