[Solved] Hyperlink to location specified in a cell

[imacanuck]

Good day.

Using the formula below:

=HYPERLINK("#Steel Sections.T2";"Go To")

Cell T2 currently contains the text "M45" which is to represent cell M45. The contents of cell T2 changes depending on the text entered into cell Q2. Is it possible to have the hyperlink go to cell M45 (or whichever cell the contents of cell T2 represents) rather than going to cell T2 and then repeat if the text in cell Q2 has been changed?

Thanks.

[Lupp]

The sequence of characters behind the leadsing # must be the actual address of the target cell (or range). If a part of that address is given in a cell, it can be -and needs to be- concatenated with the other partzs in the same way as any cocatenation is done.

Code: Select all

=HYPERLINK("#Steel_Sections." & T2;"Jump To: " & "Steel_Sections." & T2)

should do what you want.
BTW: I will only give examples with sheet names neither containing spaces nor special characters. These are sometimes creating problems.

[imacanuck]

Works perfectly, thank you Lupp.