Use cell value as reference to sheet in formula?

B

bluegnu

Hello,

I would like to use the value of a cell to be the name of a sheet in a
formula. So for instance:

A1 contains the word "Sheet1"
A2 has the formula "='Sheet1'!C3"

Rather than put the sheet name in A2, is it possible to use the value
in A1 in the formula in A2?

hope that makes sense.
 
B

bluegnu

OK, I've been using this loads, but now I've tried to using nested i
the Hyperlink function. I did this:

=HYPERLINK(INDIRECT(A1&"!C3"),INDIRECT(A1&"!C3"))

Now the friendly name bit works OK, but the hyperlink doesn't. Is i
possible to create a hyperlink using this method?

thank
 

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

Vlookup and return sheet name also 2
reference work sheet name by using a formula 3
Build a reference to another worksheet from cell values in currentsheet 3
AutoFill with sheet reference help 6
Countif contains a word in a reference cell 3
Cell highlighting question 4
formula for excel sheet. 4
Using an offset formula for the reference in a relative reference 6

Top