function and Hyperlinks

[Chris]

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]

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]

Thanks Dave - the first option worked!

Much Appreciated