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 ...
SanthoshKunder
Sep 27, 2023Iron Contributor
=INDEX($P$8:$Y$10,MATCH(P16,$P$8:$P$10,0),MATCH(YourMonthDropdowncell,$P$7:$Y$7,0))
Andyshepas
Sep 28, 2023Copper Contributor
Hi 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))
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 29, 2023Iron ContributorDon't include header in your INDEX formula.