![]() |
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 |
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