| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function and Hyperlinks
If you're bringing back the URL, you could use the =hyperlink() worksheet
function to convert it to a hyperlink. =if(iserror(vlookup(...)),"",hyperlink(vlookup(... ))) If you're not bringing back a valid URL, maybe you could add the stuff you need??? =if(iserror(vlookup(...)),"",hyperlink("http://"&vlookup(...))) or something like that. Chris wrote: 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 -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
function and Hyperlinks
Thanks Dave - the first option worked!
Much Appreciated "Dave Peterson" wrote: If you're bringing back the URL, you could use the =hyperlink() worksheet function to convert it to a hyperlink. =if(iserror(vlookup(...)),"",hyperlink(vlookup(... ))) If you're not bringing back a valid URL, maybe you could add the stuff you need??? =if(iserror(vlookup(...)),"",hyperlink("http://"&vlookup(...))) or something like that. Chris wrote: 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 -- Dave Peterson |
| Reply |
| 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 | |||
Linear Mode
