=HYPERLINK(YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Roger on Excel" wrote in message
...
|I use Vlookup all the time, but I need to pull up the hyperlink associated
| with each data entry. The hyperlinks are in one column of the parent data.
|
| Using vlookup by itself justs retrieves the text of the hyperlink, not the
| link itslelf.
|
| Can somebody help me?