function and Hyperlinks

  • Thread starter Thread starter Chris
  • Start date Start date
C

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
 
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.
 
Back
Top