Use cell value as reference to sheet in formula?

  • Thread starter Thread starter bluegnu
  • Start date Start date
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.
 
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
Excel formula, sum the value cell and if empty cell left blank 0
Cell highlighting question 4
AutoFill with sheet reference help 6
Refer to a sheet using a cell value 2
formula referring to a worksheet 3

Back
Top