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.

     

WendyJV's avatar
WendyJV
Copper Contributor
Feb 10, 2026

Thanks for your reply, I was able to do it by adding the SUMIF formula.

Olufemi7's avatar
Olufemi7
Iron Contributor
Feb 10, 2026

HelloWendyJV​, 

I am so glad that worked for you, Wendy! Since it solved the roadblock, please consider marking it as the Accepted Solution. This helps other members with similar 'Income Statement' questions find the answer more quickly. Happy Excel-ing!"