look to a cell for a reference to a sheet

  • Thread starter Thread starter Leo Demarce
  • Start date Start date
L

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
 
Hi,

=INDIRECT(A2&"!A1")

or to be safer:

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

here there are single quote as well a double quotes.
 
Back
Top