Excel Vlookup & Hyperlink

[ptw78]

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)))

 

[SkipVought]

Hi,

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

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

 

[SkipVought]

What are you trying to do?

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

 

[ptw78]

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.