Adapting Existing Formulas to Changing Months

Hi guys, a bit tricky one here...

There are working formulas, as excel file attached, only cant seem to find the way to adapt these formulas to new changing condition. Please see a screenshot and excel file attached for details. Would you be okay to suggest the solution?

Thank you.

https://www.excelforum.com/attachmen...1&d=1507330389 [EXCEL]

2017-10-07_0147.png

Hi Richard, thanks for looking into it.

I'm not quite sure what was done there... you kept the original formulas (that are not valid) as well? Its linking to C13...

D14 and E14 are same formulas to return same results?

With this version if I now select beginning of a year as 1 March, and chose Jan from a dropdown, it will still do some calculations, when Jan is not even showing in C3:F3...

Is there no way to do this formula, perhaps, without helper cells, so that: if a month in H12 match a month in C3:F3 then do calculation from balances in that particular column where months match (C4:F10) ?

I'm not understanding how helper cells works either, I see if moving them around it returns N/A values, so if trying to replicate the same in original copy of a file (which contains lots more data on that sheet) I will bump into serious issue trying to make use of this suggested workaround...

Hi Richard,

'changing conditions' was referring to changing names of the months (Jan, Feb, etc) after updating a date in A1.

I've spend a great deal of time looking for a workaround, and the simplest solution I found was to simply replace Jan, Feb etc from a dropdown box with 1,2,3, etc. So whenever, say number 3 is selected, formula will take values from column 3, regardless whether that column says Mar or Aug. So it would be down to user to just quickly take a look what month number 3 stands for.

Mission accomplished :-)

Thanks, once again, for all of your help!