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