Referencing another worksheet via a cell

  • Thread starter Thread starter tinyguppie
  • Start date Start date
T

tinyguppie

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Concatenate 2
Set non-continuous PrintArea via Function / Name 0
I can't reference a cell as the criteria in the AVERAGEIFS functio 2
count nonblank cells 3
Pulling Data from one worksheet into another 1
Interest and Payment Calculations 6
Sorting the cells of a formula causes the formula to not work 3
How do I create a summary worksheet that references data in other sheets? 2

Back
Top