Refer to sheet name specified in other cell
 

Referring to cells in other sheets requires sythax:
'sheetname'!cellname. I have the situation in which sheet name is
specified in another cell. How can I refer to cell in that sheet?

E.g.
A1 = "sheet1"

A2 = "'A1'!B3" (I would like to refer to cell B3 in sheet1)

Is that possible to do?

Marko

"Marko Pinteric" wrote in message
...

Referring to cells in other sheets requires sythax:
'sheetname'!cellname. I have the situation in which sheet name is
specified in another cell. How can I refer to cell in that sheet?
E.g.
A1 = "sheet1"
A2 = "'A1'!B3" (I would like to refer to cell B3 in sheet1)

You can use INDIRECT for this, ie:

=INDIRECT(A1&"!B3")

or some variation of same.

Rgds,
Andy

With A1 containing: Sheet1

Put in A2: =INDIRECT("'"&A1&"'!B3")

A2 will return the same as: =Sheet1!B3
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Marko Pinteric" wrote in message
...

Referring to cells in other sheets requires sythax:
'sheetname'!cellname. I have the situation in which sheet name is
specified in another cell. How can I refer to cell in that sheet?

E.g.
A1 = "sheet1"

A2 = "'A1'!B3" (I would like to refer to cell B3 in sheet1)

Is that possible to do?

Marko