VLOOKUP referencing a cell with a URL

[Guest]

I am using VLOOKUP to reference a cell on another worksheet. The contents of
that cell is a hyperlinked URL. I would like to have the hyperlinked URL
show up, but the VLOOKUP function returns only the text. How can I modify
the VLOOKUP command to return the hyperlinked URL. Thanks

 

[Guest]

Instead of =VLOOKUP()
use
=HYPERLINK(VLOOKUP())