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

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

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