Hyperlink variable on cell reference

[ZuneidDassu]

Please Login or Register  to view this content.

Hi,

I'm quite new to formulas in the excel, I'm using the above formula to create a hyperlink, however I need this to change based on a cell "G38",
"G38" shows the sheet name that I want to hyperlink to (there are 22 sheets named "Data 1" to "Data 22") and the sheet name changes depending on who opens the spreadsheet. So what I really want is something like this:

Please Login or Register  to view this content.

But I can't seem to get this to work

Hope you can help

Thanks

[martindwilson]

hyperlink acts the same as indirect so you don't need indirect at all
=HYPERLINK("#'"&G38&"'!a1","Data Page")

[XOR LX]

Hi,

You don't need INDIRECT here. Simply:

=HYPERLINK("#'"&G38&"'!A1","Data Page")

should work.

Regards

[ZuneidDassu]

Thanks very much! Works like a dream