Index with three Matches

[bchager]

Hi all,

I have original budget numbers and updated budget numbers and I need to compare the spread of budgeting between the two by project ID, cost type, and date. I am trying to accomplish this through the use of an Index/Match formula with 3 matches; one for project ID, one for cost type, and one for date. The formula appears to be working for the first month of the year, but not the others. Is it possible to use three matches in this formula?

Here is a link to the file. The formulas are in the Original Budget sheet. Pictures are attached if the link doesn't work.

Thanks in advance to anyone who can help!

 

[AhoyNC]

Maybe:
This is an array formula and must be entered with CTRL-SHIFT-ENTER

=IFERROR(INDEX('New Budget'!$C$2:$N$5,MATCH($A2&$B2,'New Budget'!$A$2:$A$5&'New Budget'!$B$2:$B$5,0),MATCH(C$1,'New Budget'!$C$1:$N$1,0)),0)

What version of Excel are you using?
It would be a good idea to update your profile with your version of Excel as the best solution can depend on the version.

 

[bchager]

Maybe:
This is an array formula and must be entered with CTRL-SHIFT-ENTER

=IFERROR(INDEX('New Budget'!$C$2:$N$5,MATCH($A2&$B2,'New Budget'!$A$2:$A$5&'New Budget'!$B$2:$B$5,0),MATCH(C$1,'New Budget'!$C$1:$N$1,0)),0)

What version of Excel are you using?
It would be a good idea to update your profile with your version of Excel as the best solution can depend on the version.

Thank you! Grouping the project ID and cost type together did the trick. I'll add my version of Excel in to my profile but it's Excel for Office 365 MSO (16.0.12527.21230) 32-bit