Referencing another worksheet via a cell
 

I have the following simple formula

=Sheet1!B15

which of course prints the contents of "Sheet1" cell B15.

However what I want is to get which worksheet to grab from, from a
cell. Ie

1
A Sheet1

And then the formula would be something like

A1!B15


Is this possible? I tried a few combinations and couldnt get it
working.

Thanks!!!

Referencing another worksheet via a cell
 

Look in help for the Indirect function

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



wrote in message oups.com...
I have the following simple formula

=Sheet1!B15

which of course prints the contents of "Sheet1" cell B15.

However what I want is to get which worksheet to grab from, from a
cell. Ie

1
A Sheet1

And then the formula would be something like

A1!B15


Is this possible? I tried a few combinations and couldnt get it
working.

Thanks!!!

Referencing another worksheet via a cell
 

Perfect - Thanks alot Ron.

Ironically my searching of the newsgroup had me about to lookup help on
INDIRECT anwyay, just as your post came in! :)