Vlookup to retrieve a hyperlink
 

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?

Vlookup to retrieve a hyperlink
 

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

this will convert "cold" text into a "hot" hyperlink
--
Gary''s Student - gsnu200753


"Roger on Excel" wrote:

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?

Vlookup to retrieve a hyperlink
 

=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?