Referencing another worksheet via a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tinyguppie@hotmail.com - 31 Oct 2006 20:07 GMT

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!!!

Reply to this Message

Ron de Bruin - 31 Oct 2006 20:18 GMT

Look in help for the Indirect function

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

Signature

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

>I have the following simple formula
>
[quoted text clipped - 16 lines]
>
> Thanks!!!

Reply to this Message

tinyguppie@hotmail.com - 31 Oct 2006 20:22 GMT

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! :)

Reply to this Message