Offset Function Help

Question

I have a budget template that works perfectly with the exception of 8 finals cells.&nbsp; These cells need the same type of formula/function, but I am not sure how to create this.&nbsp; &nbsp;On the Overview tab of the workbook, I'd like to have a drop-down menu where I can select the month.Once selected the spreadsheet will display the YTD and Monthly totals as of that month for both budget and actuals.&nbsp;&nbsp;I have attached my spreadsheet and highlighted 8 cells in yellow that need a formula.&nbsp;I have a spreadsheet where this formula works, but I am unable to replicate it in the new spreadsheet

tauqeeracma · Answer

Hi jennhr&nbsp;&nbsp;I have copied required formula in Master Budget template, please let me know if it works as you desired.&nbsp;Overview tab already have drop-down list that show different months.&nbsp;ThanksTauqeer

jennhr · Answer

tauqeeracma&nbsp; Thank you so much for your quick response.&nbsp; &nbsp;There was an error in a couple of the cells but the formula worked in many of the cells.&nbsp; One tweak and it worked.&nbsp; thank you again.&nbsp;

Forum Discussion

Offset Function Help

2 Replies

Resources