Forum Discussion
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 ...
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))
Don't include header in your INDEX formula.