Forum Discussion
Andyshepas
Sep 26, 2023Copper Contributor
Excel Formula
Hi, As discussed please look at the below. The issue I have is with the Dashboard tab. Everything has a formula except Column C ‘Budgeted’ as this needs a monthly manual input and can ...
Andyshepas
Sep 27, 2023Copper Contributor
I guess that’s part of the question. Do I need a separate table for the budgets amount?
SanthoshKunder
Sep 27, 2023Iron Contributor
Andyshepasyou should keep a distinct table for your monthly budget information. Kindly refer to the provided screenshot for guidance.
- SanthoshKunderSep 29, 2023Iron ContributorDon't include header in your INDEX formula.
- AndyshepasSep 28, 2023Copper ContributorHi Santos,
Still struggling to get this to work, it keeps returning the type e.g. ‘Clare Salary’ - =INDEX(Sheet1!$A$4:$C$10,MATCH(A5,Sheet1!$A$4:$A$10,0), MATCH($B$3, Sheet1!$B$2:$C$2,0)) - SanthoshKunderSep 27, 2023Iron Contributor=INDEX($P$8:$Y$10,MATCH(P16,$P$8:$P$10,0),MATCH(YourMonthDropdowncell,$P$7:$Y$7,0))
- AndyshepasSep 27, 2023Copper ContributorSorry I can see the formula now.
- AndyshepasSep 27, 2023Copper ContributorI can’t see the actual formula. Could you send it please.
- SanthoshKunderSep 27, 2023Iron ContributorThe formula I provided already accounts for this. It references the month field. However, ensure that your 'budget' data follows the format shown in the screenshot above.
- AndyshepasSep 27, 2023Copper ContributorYes, makes sense thanks. I guess the only thing I’m missing is how do I get the table to reference the drop down so that when you change the month it automatically selects the correct numbers. Thanks