Refer to sheet name specified in other cell

M

Marko Pinteric

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
 
A

Andy Brown

Marko Pinteric said:
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)
Click to expand...

You can use INDIRECT for this, ie:

=INDIRECT(A1&"!B3")

or some variation of same.

Rgds,
Andy
 
M

Max

With A1 containing: Sheet1

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

A2 will return the same as: =Sheet1!B3
 
Top