ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vlookup and Hyperlink (https://www.excelbanter.com/excel-programming/348158-vlookup-hyperlink.html)

justaguyfromky

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

Kleev

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



All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com