OFFSET formula help.

[mc2468]

Hi,

I'm wondering if anyone can help me with the attached S/S. On the first sheet (YTD) i would like to get a Budget YTD figure for the month selected in B2 for each location in column B from the figures listed on the 2nd sheet (Budget Figures).

Any help would be much appreciated.

Thanks in advance.

[Ace_XL]

In C5

=SUM(INDEX('Budget Figures'!$C$3:$G$3,MATCH(B5,'Budget Figures'!$C$1:$G$1,0)):INDEX(INDEX('Budget Figures'!$C$3:$G$14,MATCH($B$2,'Budget Figures'!$A$3:$A$14,0),0),MATCH(B5,'Budget Figures'!$C$1:$G$1,0)))

Copy down

[mc2468]

Wow! That was quick. Thank you so much. That's working perfectly.

Much appreciated.

[MarvinP]

Hi mc,

The formula you are looking for is a Index Match type and looks like this awful thing:

=INDEX('Budget Figures'!$C$3:$G$14,MATCH(YTD!$B$2,'Budget Figures'!$A$3:$A$14,0),MATCH(B5,'Budget Figures'!$C$1:$G$1,0))

Find the attached so you can check to see if it is what you need.

I'm not sure we all are giving you the same answers. You'd better do some testing with all this help.

[dilipandey]

Okay.. use below formula:-

Please Login or Register  to view this content.

Budget YTD Formula.xlsx

Regards,
DILIPandey
<click on below * if this helps>