Formula to use content of cell as sheet reference

[jwillis07]

Hi all,

Is it possible to use the contents of a cell to point to the location of another cell within a different sheet. For example...

---A------B-----
1-Y7
2-C4

In A1 is the name of the other sheet, in A2 is the cell in sheet Y7 I want to lookup.

My best guest is:

="'"&A1&"'!"&A2

but that just shows the the cell location as a text string like this... 'Y7'!C4


Thanks in advance,

Jason

[Pete_UK]

You need to use INDIRECT to convert that string into a reference that Excel can make use of, like this:

=INDIRECT("'"&A1&"'!"&A2)

Hope this helps.

Pete

[jwillis07]

Lovely. Thank you very much. Knew it was only missing a piece.