B
Bill
I have a summary page and in one column there are hyperlinks to a cell on
another worksheet. In the next column, I would like to use the value of that
hyperlinked cell if a hyperlink exists there. So I need something like
(assuming it's in cell B1)
=SomeFormula + If(IfExistHyperlinkIn(A1), Indirect(a1), 0)
I have tried but can't figure it out. Could someone help?
Also, I see that a hyperlink can be added by right clicking and selecting
from the popup menu or by using the HYPERLINK worksheet function. Any
difference between these methods and any pros or cons?
another worksheet. In the next column, I would like to use the value of that
hyperlinked cell if a hyperlink exists there. So I need something like
(assuming it's in cell B1)
=SomeFormula + If(IfExistHyperlinkIn(A1), Indirect(a1), 0)
I have tried but can't figure it out. Could someone help?
Also, I see that a hyperlink can be added by right clicking and selecting
from the popup menu or by using the HYPERLINK worksheet function. Any
difference between these methods and any pros or cons?