Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK AND VLOOKUP help
Hello,
I am trying to find a way to combine the Hyperlink and Vlookup finctions. Specifically, I would like to enter text into a cell and have that text automatically hyperlink to what I need, either a file or URL. For example: If I enter the word "History" into cell A:1, I would want it to automatically create a hyperlink to historychannel.com, without any change to the original word I input into the cell. I thought I could do this by combining the VLOOKUP and HYPERLINK functions, but it has not quite worked out for me yet. Any help would be greatly appreciated. Thanks in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HYPERLINK AND VLOOKUP help
An example ..
If A1 contains the data/formula (eg vlookup) returned value of: yahoo this in B1: =HYPERLINK("http://www."&A1&".com",A1) will produce the required hyperlink -- Max Singapore http://savefile.com/projects/236895 Downloads:23,000 Files:370 Subscribers:66 xdemechanik --- "ISAF Media Analysis" wrote: I am trying to find a way to combine the Hyperlink and Vlookup finctions. Specifically, I would like to enter text into a cell and have that text automatically hyperlink to what I need, either a file or URL. For example: If I enter the word "History" into cell A:1, I would want it to automatically create a hyperlink to historychannel.com, without any change to the original word I input into the cell. I thought I could do this by combining the VLOOKUP and HYPERLINK functions, but it has not quite worked out for me yet. Any help would be greatly appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HYPERLINK and VLOOKUP help | Excel Discussion (Misc queries) | |||
HYPERLINK AND VLOOKUP help | Excel Discussion (Misc queries) | |||
Vlookup to retrieve a hyperlink | Excel Discussion (Misc queries) | |||
hyperlink with vlookup | Excel Discussion (Misc queries) | |||
vlookup hyperlink | Excel Discussion (Misc queries) |