Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
function and Hyperlinks
Hi - I have a VLOOKUP embedded in an IF function that refers to Hyperlinks.
Is there a way to bring across an active hyperlink instead of the url or hyperlink text? The function I am using is: =IF(ISERROR(VLOOKUP($C27,Lists!$A$14:$E$73,3,FALSE )),"",VLOOKUP($C27,Lists!$A$14:$E$73,3,FALSE)) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a function that saves hyperlinks from excel to new folde. | Excel Discussion (Misc queries) | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
Using Hyperlinks with the Index function. | Excel Worksheet Functions | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions |