Assume Sheet1 has indexed sheetnames in Column A.
=INDIRECT("'"&$A$3&"'!B4")
The above formula in A9 on Sheet1 will return the cell contents of B4 from the indexed sheetname in A3.
How would I adjust my formula if I wanted A9 on Sheet2 to populate from B4 of the sheetname in A3 on Sheet1?
TIA
=INDIRECT("'"&$A$3&"'!B4")
The above formula in A9 on Sheet1 will return the cell contents of B4 from the indexed sheetname in A3.
How would I adjust my formula if I wanted A9 on Sheet2 to populate from B4 of the sheetname in A3 on Sheet1?
TIA