Forum Discussion
INDEX MATCH with VLOOKUP
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.
You could help the rest of us help you by giving a little more specific details to help decode your code.
Ideally, though I realize this is probably highly personal (or confidential in some other way) information, you would attach either a copy of the actual workbook OR a mockup of that...dummy data only, but a chance to see what kind of information you are using for those MATCH sections of this formula.
It's entirely possible that you could use the FILTER function to select a row or a few rows from the two-thousand + rows of the original source data.
All of that aside, to help us visualize your data, and thereby also get a handle on what you're trying to do, answers to the following questions might help if you're not able to post the file (or mockup) and are unable to make FILTER work.
- What type of data is in $A7 and why is it $A7 and not $A$7 or any other variant?
- What type of data is in C$1, and why is it C$1 and not any of the other variants?
- How does C$1 related to $A$4:$AB$4? I'm presuming the latter are column headers....but it would help if you weren't forcing us to guess.
Decoding (to say nothing of fixing) a formula somebody else has written is hard enough without having also to guess at what the various references refer to,
Thanks for your reply, I was able to do it by adding the SUMIF formula.
