Budget to Actual Table
In the Budget to Actual table there is an amount in cell L9. I want to populate the data from a separate table (2019 Actuals) using the column headers 1,2,3,4 etc representing each month of the year simply by entering a number representing the month in cell N5.
In other words, I want excel to pull the data out of the 2019 Actual table based on a given month using the column header and the amount must be specific to the account number in each row.
For example, it is February and I enter 2 into cell N5 and the number 50 (from the 2019 actuals table) will populate in cell L9.
I tried using the Hlookup formula, but you cannot copy the formula down.
Also, how could I sum cumulative data in the same way. For example, I want to sum the data in the same way year-to-date. If it is March, then I need the sum of 3 months worth of data in cell S9 after inputting the number 3 into cell N5.
What can I do without having multiple formulas in each cell. Ideally, I would like one formula in each cell of the table.