Hyperlink/Vlookup error: cannot open specified file

[bsolomon]

Hi,

Pretty new to excel formulas.

I'll lay it all out....

I would like to use (Cell=G18) on my master worksheet to return a usable hyperlink specific to cells in another workbook that has pdf's attached.

In my master workbook, (Cell=G4) has a vlookup formula that returns a result from a the separate workbook. This result is what i'm looking to also show in (Cell=G18).

This is my current formula.
=HYPERLINK(VLOOKUP(G4,'[ADAMS PRICE CHART.xlsx]VLOOKUP WORKSHEET'!$A$2:$A$74,1,FALSE))

I'm currently getting an error: cannot open the specified file.

The correct cell information populates.


Hopefully that makes sense.

Thanks in advance!

 

[BiocideJ]

I'm a bit confused by the formula. What is the purpose of the VLOOKUP? It seems like you are looking up the value in G4 and returning the same matching value from the VLOOKUP WORKSHEET.
I guess I don't see the difference of just doing =HYPERLINK(G4)
What is the value of G4? Or at least a sanitized version like \\myserver\mpath\myfile.xlsx to help me (and everyone) better understand what is going on here.

 

[bsolomon]

Thanks for the response. I'm simply googling everything...so my formula is most likely wrong.

I have a worksheet in a separate workbook with all of the information and hyperlinks attached within cells A2:A74. ('[ADAMS PRICE CHART.xlsx]VLOOKUP WORKSHEET'!$A$2:$A$74)

In my master workbook, I cell G18, to match Cell G4's results, but pull the exact information from ('[ADAMS PRICE CHART.xlsx]VLOOKUP WORKSHEET'!$A$2:$A$74) these cells. These cells have the pdf hyperlinks attached.

Sorry if my description is lacking the technical terminology.

I'm a bit confused by the formula. What is the purpose of the VLOOKUP? It seems like you are looking up the value in G4 and returning the same matching value from the VLOOKUP WORKSHEET.
I guess I don't see the difference of just doing =HYPERLINK(G4)
What is the value of G4? Or at least a sanitized version like \\myserver\mpath\myfile.xlsx to help me (and everyone) better understand what is going on here.