Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can vlookup be used to retrieve multiple matches | Excel Discussion (Misc queries) | |||
vlookup doesn't retrieve subscript formatting Why? | Excel Discussion (Misc queries) | |||
hyperlink with vlookup | Excel Discussion (Misc queries) | |||
vlookup hyperlink | Excel Discussion (Misc queries) | |||
DropDown with VLOOKUP & HYPERLINK | Excel Worksheet Functions |