Vlookup with hyperlink not working when source file is closed

[Patricya]

I'm creating in inventory file for the products we'll receive each year. In this file a lot of information has to be available (supplier, product #, lot #, has the package insert been verified....). To make the process easier, I created a data base file that contain these informations and in the inventory file I use Vlookup formula to populate the inventory but I have a problem with one formula for a hyperlink. Since the package insert for the product has to be retreived from the web site of the supplier, I use the following formula =hyperlink(iferror(vlookup($B273;'W:\DSMC\6.0 Laboratoires\1-Régional (tronc commun)\G6 – Ressources matérielles\Base de données\[Catalogue 2023.xlsx]sheet1'!$A:$E;5;FAUX);"")). The formula is "working" the web site address appears but when I click on it the web page does not open unless the data base file is open. Does any one have a solution?

 

[Deek6t8]

You would be much better querying the detail required in from the Catalogue file using Power Query and then referencing it within your workbook to avoid the workbook having external links which can be unreliable and require updating.