Forum Discussion

Msusma's avatar
Msusma
Copper Contributor
Nov 22, 2020

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 

excel
office 365
training

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Nov 22, 2020

    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.

Resources