Dear all
I have a sheet named "ACA"
I have this formula in A2: "=INDIRECT("ACA!GJ5")"
I have a value in A1 named after the sheet: ACA
My question is: instead of using the sheet name as it is in the formula, can I instead refer to the content of A1, which is the name of the sheet?
Basically what I want is to replace the sheet name in the formula with the cell content.
Thanks in advance!
I have a sheet named "ACA"
I have this formula in A2: "=INDIRECT("ACA!GJ5")"
I have a value in A1 named after the sheet: ACA
My question is: instead of using the sheet name as it is in the formula, can I instead refer to the content of A1, which is the name of the sheet?
Basically what I want is to replace the sheet name in the formula with the cell content.
Thanks in advance!