Formula help INDEX and MATCH Please :)

[BeckyLH88]

Hello all,

I have added a formula, which on the first input returns the right result.

But when I drag this down, it then returns the result of the cell before but the result of the right so therefore moves the look up onto the next month.

Here's my formula:

=SUMIF('[Budget FY2024.xlsx] Budget'!$C$3:$N$3,$E$3,INDEX('[Budget FY2024.xlsx] Budget'!$C$6:$N$133,0,MATCH($B7,'[Budget FY2024.xlsx] Budget'!$B$6:$B$133,0)))

C3 - N3 being the date range
E3 is the date to be looked up
C6 - N133 being the range of data
B7 is the text for example 'staff costs' to look up
B6 - B133 is the text range

So for example:

1st October staff cost is 10, the first field has 10 returned. Formula is then dragged down, the look up changes to office costs, but then it brings the November Staff cost into this figure.


Really appreciate the help. Thank you in advance

 

[steve the fish]

Do you understand SUMIF? So the first part is the criteria range which in this case needs to look at the products, the 2nd is the criteria so needs to point at 'Product 1' etc. The 3rd is the sum range and is using the INDEX to chop the number columns based on the date in the MATCH.

 

[BeckyLH88]

Thank you for all your help, I've used a different formula and solved it.