How do I use HYPERLINK function with INDIRECT function?

%3CLINGO-SUB%20id%3D%22lingo-sub-1921594%22%20slang%3D%22en-US%22%3EHow%20do%20I%20use%20HYPERLINK%20function%20with%20INDIRECT%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921594%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20link%20a%20cell%20that%20already%20has%20a%20INDIRECT%20function%20on%20it.%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20formulae%20is%26nbsp%3B%3D%40INDIRECT(%22'%22%26amp%3BD10%26amp%3B%22'!F8%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20advice.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Etraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1921658%22%20slang%3D%22de-DE%22%3ESubject%3A%20How%20do%20I%20use%20HYPERLINK%20function%20with%20INDIRECT%20function%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921658%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F877832%22%20target%3D%22_blank%22%3E%40Msusma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EINDIRECT%20requires%20the%20value%20in%20the%20cell%20referenced%20to%20provide%20the%20reference%20of%20what%20INDIRECT%20returns.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20what%20you%20want%20to%20have%20is%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%3DHYPERLINK(%22%22%22%20%26amp%3B%20D10%20%26amp%3B%20%22'!F8%22%2C%20D10)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fdmcritchie.mvps.org%2Fexcel%2Findirect.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fdmcritchie.mvps.org%2Fexcel%2Findirect.htm%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 

1 Reply
Highlighted

@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.