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
|