A
atran
Is it possible to have a sheet reference in a formula that is based on
referenced cell?
For example, if I have the following formula in cell A1(Sheet1):
=Sheet2!A1, then I have a list of Sheets ie. Sheet 3, Sheet 4, Sheet
in cells C1:C3 respectively, can I create a formula that will look a
C1:C3 for the corresponding "sheet reference" to look up?
Many thanks
referenced cell?
For example, if I have the following formula in cell A1(Sheet1):
=Sheet2!A1, then I have a list of Sheets ie. Sheet 3, Sheet 4, Sheet
in cells C1:C3 respectively, can I create a formula that will look a
C1:C3 for the corresponding "sheet reference" to look up?
Many thanks