Vlookup to retrieve a hyperlink

R

Roger on Excel

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

Gary''s Student

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

this will convert "cold" text into a "hot" hyperlink
 
N

Niek Otten

=HYPERLINK(YourFormula)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

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