I am struggling with an Indirect formula which is designed to link two worksheets, one called "Report" and one called "Budget".
I want to change the name of the worksheet called "Budget" to the name of "Annual Accounting". When I do this though, I get the error #REF! in the cell #B23 where the formula below is in. Can you advise me how to edit the name of the worksheet without messing up the formula?
Formula:
=SUM(OFFSET(INDIRECT("Budget!A"&MATCH(Report!A23,Budget!$A:$A,0)),0,IF(ytd,1,$B$5),1,IF(ytd,$B$5,1)))
I attached of the area where I'm getting the error.
Thank you-Max
Spreadsheet Screenshot.jpg
Bookmarks