Hyperlink formula with destination in same worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following formula gives the error of "Cannot open the specified file".
=HYPERLINK(H1,"X")
When cell H1 contains a string, if the cell is empty nothing happens.

I'm looking for a way to have the result of a formula be a hyperlink to a
cell within the same worksheet such that the hyperlink only shows when
specific conditions are met. Such as: =IF(A1="Y",HYPERLINK(H1,"X"),"").
Thanks.
 
Maybe you could just link to the cell that contains the formula:

With this formula in A2:
=IF(A1="Y",HYPERLINK(H1,"X"),HYPERLINK("#"&CELL("address",A2),""))
or equivalently:
=HYPERLINK(IF(A1="y",H1,"#"&CELL("address",A2)),IF(A1="y","X",""))
 
Back
Top