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
|