Forum Discussion
NProudfoot
Dec 27, 2023Copper Contributor
Excel formula
=IFERROR(INDEX(FINAL!K13:V383;MATCH('Expense Budget'!B3;FINAL!D13:D160;0);MATCH(FINAL!K12:V12;0));0)
Not calculating - I need info to be calculated for budgetting purposes Please can anyone assist?
1 Reply
I think you want
=IFERROR(INDEX(FINAL!$K$13:$V$383;MATCH($B3;FINAL!$D$13:$D$383;0);MATCH(C$1;FINAL!$K$12:$V$12;0));0)