I am trying to link a cell that already has a INDIRECT function on it.
My formulae is =@INDIRECT("'"&D10&"'!F8").
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)
I would be happy to know if I could help.
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.