How do I use HYPERLINK function with INDIRECT function?

[Msusma]

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 

[#2]

@Msusma 

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.