vlookup and hyperlink

[Leyluna77]

Hello,
I need some help as I never had any training on excel and I'm lost! I need to retrieve airwaybills with hyperlinks. To do so I have tried a =HYPERLINK(VLOOKUP(F2,exacta!A:N,14,0)) however when I click on the link I get an error message (Cannot open the specified file). I've tried some stuff I found on forum (like creating a VBA (my first one by the way) to get the URL but it only worked the first time so I don't know why I wasn't able to make a secon miracle . Anyway, the url displayed with a 'so the link wasn't working anymore.
So do you have any idea? Thanks a lot in advance

 

[Special-K99]

If the hyperlink is a link to another sheet in the same spreadsheet you need to preced it by "#" and have a cell referenced, like

=HYPERLINK("#"&VLOOKUP(F2,exacta!A:N,14,0)&"!A1")

 

[Leyluna77]

Thank you . It didn't work so I tried to modify the formula =HYPERLINK(""&VLOOKUP(F2,exacta!A:N,14,0)) and I didn't have the error message anymore. However when I remove the formula with a copy paste value, the hyperlinks disappear. As I have more than 1000 lines i would like to avoid adding the hyperlinks one by one. Any idea?

 

[Special-K99]

Are you trying to Hyperlink WITHIN the same file to a different sheet or something external ?
My solution was to a sheet within the same file as already stated.

 

[Leyluna77]

Yes it is in the same file but in different sheets.

 

[Special-K99]

That formula should work (unless your VLOOKUP is failing)