Formulas won't return the links, but depending on what you're returning, maybe
you could use that to build the hyperlink:

=hyperlink(vlookup(...))
or
=hyperlink("mailto:" & vlookup(...))

But that value returned has to be the link--not just a nice displayed
name/string.





KarenF wrote:

Hi,

I am using VLookups to populate several workbooks with data from a master
workbook. My current problem is that on the master book, there are e-mail
addresses which are currently hyperlinked. When I use the VLookup to
populate my cells with e-mail addresses, is there any way that I can keep the
hyperlinked properties of the data?

Many thanks,

Karen

--

Dave Peterson