Home

Help linking to a specifice cell

%3CLINGO-SUB%20id%3D%22lingo-sub-697815%22%20slang%3D%22en-US%22%3EHelp%20linking%20to%20a%20specifice%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-697815%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20create%20a%20hyperlink%20in%20a%20cell%20only%20if%20I%20enter%20a%20value%20in%20it.%20I%20want%20this%20to%20link%20to%20a%20specific%20cell%20on%20another%20worksheet.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20input%20the%20letter%20x%20into%20a%20cell%20(Sheet15%20B2)%20I%20would%20like%20it%20to%20become%20a%20link%20to%20another%20specific%20cell%20(Sheet%2016%20A1).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20his%20something%20that%20is%20possible%3F%20Any%20help%20is%20appreciated.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-697815%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698020%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20linking%20to%20a%20specifice%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698020%22%20slang%3D%22en-US%22%3EWith%20formula%2C%20that%E2%80%99s%20not%20possible.%20The%20input%20cell%20must%20be%20different%20from%20the%20cell%20with%20the%20HYPERLINK%20formula.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698063%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20linking%20to%20a%20specifice%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698063%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20response.%20What%20can%20I%20do%20to%20solve%20this.%20What%20I%20am%20essentially%20doing%20is%20creating%20a%20table%20that%20when%20a%20cell%20is%20%22checked%22%2C%20I%20want%20it%20to%20be%20a%20hyperlink%20to%20another%20cell%20on%20a%20different%20worksheet%20for%20additional%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-698232%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20linking%20to%20a%20specifice%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698232%22%20slang%3D%22en-US%22%3EAs%20I%20stated%20earlier%2C%20the%20input%20cell%20must%20be%20different%20from%20the%20formula%20cell.%3C%2FLINGO-BODY%3E
tlaven
New Contributor

I am trying to create a hyperlink in a cell only if I enter a value in it. I want this to link to a specific cell on another worksheet.

 

If I input the letter x into a cell (Sheet15 B2) I would like it to become a link to another specific cell (Sheet 16 A1).

 

Is his something that is possible? Any help is appreciated. Thanks.

3 Replies
With formula, that’s not possible. The input cell must be different from the cell with the HYPERLINK formula.

Thanks for the response. What can I do to solve this. What I am essentially doing is creating a table that when a cell is "checked", I want it to be a hyperlink to another cell on a different worksheet for additional information.

As I stated earlier, the input cell must be different from the formula cell.