Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Vlookup & Hyperlink

Status
Not open for further replies.

ptw78

Technical User
Mar 5, 2009
155
US
I cannot get this Hyperlink/Vlookup to work. It will show the lookup value as a hyperlink, but when I click on it it says "Cannot open specified file."
When I click the link on the source page it does open. Any suggestions on this? thx

=HYPERLINK(VLOOKUP(C6,'Investor Matrix'!1:2295,4,FALSE),(VLOOKUP(C6,'Investor Matrix'!1:2295,4,FALSE)))
 


Hi,

Lookup functions return a VALUE, not a reference, which is what a hyperlink wants.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 


What are you trying to do?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
Yea I finally find out what the issue was.
But basically what I have is a link on one sheet(sheet2) can call it "Link A" and on another sheet(sheet1) I have a Vlookup where I want to have the value the Vlookup returns as a link("Link B") which is =HYPERLINK(VLOOKUP(C6,'Investor Matrix'!1:2295,4,FALSE),(VLOOKUP(C6,'Investor Matrix'!1:2295,4,FALSE))) . So basically it's just a link to a link I'm guessing, which I've found out you can't do w/basic functions. Can this be done via VBA?

I have a work around which is just make "Link A" the direct path and use =HYPERLINK(VLOOKUP(C6,'Investor Matrix'!1:2295,4,FALSE),"Name Link A")

But I was hoping to get the name of Link A instead of having to put the path in.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top