Forum Discussion

tlaven's avatar
tlaven
Copper Contributor
Jun 17, 2019

Help linking to a specifice cell

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 li...
excel
Twifoo's avatar
Twifoo
Silver Contributor
Jun 17, 2019
With formula, that’s not possible. The input cell must be different from the cell with the HYPERLINK formula.
tlaven's avatar
tlaven
Copper Contributor
Jun 17, 2019

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.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Jun 17, 2019
    As I stated earlier, the input cell must be different from the formula cell.