Forum Discussion

NProudfoot's avatar
NProudfoot
Copper Contributor
Dec 27, 2023

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

  • NProudfoot 

    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)

Resources