Forum Discussion
How do I use HYPERLINK function with INDIRECT function?
I am trying to link a cell that already has a INDIRECT function on it. My formulae is =@INDIRECT("'"&D10&"'!F8"). Please advice. Thank you
INDIRECT requires the value in the cell referenced to provide the reference of what INDIRECT returns.
I think what you want to have is something like this:
=HYPERLINK("#'" & D10 & "'!F8", D10)
http://dmcritchie.mvps.org/excel/indirect.htm
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.