Forum Discussion
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 anyon...
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)