Excel Hyperlink function with indirect link 2

bluegnu · Jul 21, 2006

I use the following function in excel to display day from one sheet on another using a cell reference rather than the worksheet reference:

=INDIRECT (A1&"!C3")

This means that people can type the name of their worksheet in cell A1 and the contents of cell C3 of that worksheet will be displayed.

What I want to do now is enhance that by creating a hyperlink to that cell reference, but I can't get it to work. If I do:

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

Then it displays the contents of the cell correctly, but the hyperlink doesn't work.

Is it possible for me to get this to work?

many thankd

GlennUK · Jul 21, 2006

You don't need the INDIRECT function in there ...
=HYPERLINK("#"&A1&"!C3",A1&"!C3")

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

bluegnu · Jul 21, 2006

Thanks Glenn, now the hyperlink works but the display the friendly text shows the contents of A1 plus !C3

(So if the contents of A1 was 123, the friendly text shows as 123!C3)

Any ideas?

GlennUK · Jul 21, 2006

You can put the INDIRECT for the friendly text, ( silly me ), you just omit it for the first part.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

bluegnu · Jul 21, 2006

Yep - that's done it. Many thanks.

GlennUK · Jul 21, 2006

My pleasure :-D

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Excel Hyperlink function with indirect link 2

bluegnu

Technical User

GlennUK

MIS

bluegnu

Technical User

GlennUK

MIS

bluegnu

Technical User

GlennUK

MIS

Similar threads

Part and Inventory Search

Sponsor