look to a cell for a reference to a sheet

[Leo Demarce]

I have a formula in Sheet3 in cell A1 that is something like this:

=Sheet1!A1

This formula of course is looking to Sheet1 for the contents in cell A1 and
placing it in cell A1 of Sheet3.

In Sheet3 I have in cell A2 the following text Sheet1.

What I would like my formula to do is to look in cell A2 of Sheet3 for what
sheet to look for. For example, instead of =Sheet1!A1 it would be something
like =A2!A1

I know this doesn't work, but how do I reference the contents of cell A2 to
give me the sheet number that I want to reference.
Cheers

 

[Shane Devenshire]

Hi,

=INDIRECT(A2&"!A1")

or to be safer:

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

here there are single quote as well a double quotes.

 

[Niek Otten]

Hi Leo,

Look in HELP for the INDIRECT() function