Need help moving web hyperlinks from one excell document to another.

Good morning everybody,

I have two excel documents and i need to automatically copy links to certain webpages from one document to another.

To be more specific, i have one excel document containing a price list with product codes and one document containing a list of stocks that has the same product codes in different order. The list of stocks is chainging daily and i need to find a way to move the product code hyper links from the price list to the newly generated list of stocks.

Is there a VLOOKUP formula for this ?

Thank you !