Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup and Hyperlink
I have a cell that I want use vlookup to find an internet address in a table
on another sheet to insert the internet address in. In the table, the link will go strait to the site if I click on it. When VLOOKUP puts the address in the cell, it will not access the internet. Is there something that I am missing, or is this just not possible. Any help will be appreciated. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Vlookup and Hyperlink
This worked for me:
=HYPERLINK(VLOOKUP(A26,A4:B24,2,FALSE)) "justaguyfromky" wrote: I have a cell that I want use vlookup to find an internet address in a table on another sheet to insert the internet address in. In the table, the link will go strait to the site if I click on it. When VLOOKUP puts the address in the cell, it will not access the internet. Is there something that I am missing, or is this just not possible. Any help will be appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink w/ vlookup | Excel Discussion (Misc queries) | |||
using vlookup and hyperlink | Excel Worksheet Functions | |||
HYPERLINK and VLOOKUP help | Excel Discussion (Misc queries) | |||
HYPERLINK AND VLOOKUP help | Excel Worksheet Functions | |||
HYPERLINK AND VLOOKUP help | Excel Discussion (Misc queries) |