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

If you type the formula in A2 as:-

Indirect(A1&"!B3")

This should pick up the cell value of B3 in the sheet name entered into A1

"Marko Pinteric" <[email protected]> wrote in message
news:[email protected]...
>
> 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 <at>yahoo<dot>com
----
"Marko Pinteric" <[email protected]> wrote in message
news:[email protected]...
>
> 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