I am trying to create a more robust budget and invoice tracking sheet.
I track contract values, changes and budgets on worksheet that are named by the financial accounting node they are associated with.
I have a column in my project budget sheet that needs to reflect the total value of each sheets contract values and $$ paid to date.
Is there a way to create a formula that will read something like this - If the Node in Column B equals a sheet name, return value from B37? If false, Zero.
I have tried =IF(ISNUMBER(SEARCH("1.06",sheetnames)),'1.06'!B35, 0) to no avail. Should this be an indirect formula?
See attached Sheet for reference. thanks so much for the help.
I track contract values, changes and budgets on worksheet that are named by the financial accounting node they are associated with.
I have a column in my project budget sheet that needs to reflect the total value of each sheets contract values and $$ paid to date.
Is there a way to create a formula that will read something like this - If the Node in Column B equals a sheet name, return value from B37? If false, Zero.
I have tried =IF(ISNUMBER(SEARCH("1.06",sheetnames)),'1.06'!B35, 0) to no avail. Should this be an indirect formula?
See attached Sheet for reference. thanks so much for the help.
