How to get the Offset Value of the Reference of Within Another Cell

[ChrisHook]

All,

I'm curious if this is possible. Say if I have Sheets 1, 2, and 3. If...

- In cell A1 of Sheet 3 I have the number 4, and in Cell B1 I have the number 5.

- In cell A2 of Sheet 2 I have the formula ='Sheet 3!A1


Is it possible to write an offset function (say, =offset(reference,0,1) to refer to the formula in sheet 2, thus pulling the value from sheet 3 Cell C2?

Essentially, wondering if offset (or another formula like it) would be able to refer to the cell reference within the cell that it is pulling from.

[XLent]

If as denoted in your profile you're using 2013 then you have FORMULATEXT function available which, in this simplistic scenario, you could use in conjunction with other functions to do what you're asking - e.g.:

Please Login or Register  to view this content.

prior to that function being available you'd have to use VBA / XLM call to expose the precedent range in your Sheet2!A2 range.