| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
following a hyperlink
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
| Hyperlink Length | Excel Worksheet Functions | |||
| Removing hyperlink | Excel Discussion (Misc queries) | |||
Linear Mode
