Forum Discussion
How to use a varaible in a formula
Hi, This formula: ='[FE Project Revenue Tracking 2023 (August 2023).xlsx]August'!$F6 I want the sheet/tab name to be variable. I have this name in L1 of sheet and I want to be able to chan...
I have something very similar to that and make use of the INDIRECT function to accomplish the task. Just be forewarned that INDIRECT should be used sparingly in any workbook; excessive use can slow down all calculations.