Forum Discussion
Solved
A formula that changes the sheet reference based on cell value with sheet name
Hi, I am making an executive report on one page which pulls all the findings from each individual sheet into one sheet. I have 35 different tables which each reference one sheet (which I have 35...
Is there a way to use the INDIRECT formula within a formula i.e. replacing the reference "Sheet1" in this formula?
=MIN('Sheet1'!$C$46:$C$2078)
=MIN('Sheet1'!$C$46:$C$2078)
- Cheers!
That worked, now I just have to get my head around it!