Hello all,
How can I refer to a sheet in a formula without using the sheets name directly in the formula, but by having the sheets name in a cell. For example:
Say I have 2 sheets, Sheet1 and Sheet2
In Sheet1 in a cell, I could put this: =Sheet2!B4. That will return the value in B4 of sheet2
I want to do the same thing, but without actually using the name of the sheet. I'll have the name of the sheet in a cell instead. So if I have the text: "Sheet2" in cell A1 of Sheet1, I want to have the formula read like this instead:
=A1!B4 because A1's value is Sheet2. I know there's a way to do it, but I can't remember what it is.
This formula: =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)
is not what I'm looking for. That returns the name of the sheet the formula is in.
Thank you!
Bookmarks