Greetings,

I am trying to create a dynamic hyperlink to corresponding PDF documents based on invoice reference numbers that are contained in an excel sheet.

For example:

Reference Numbers in excel:

11002
11003
11004
11005

I then have a google drive folder that contains PDF files to support that reference number:

11002PUS
11003PUS
11004PUS
11005PUS

Is it possible to create a hyperlink formula that utilizes the reference number to then look up and link the corresponding file in the google drive folder? an external Vlookup that creates a hyperlink of sorts?

Thank you for the help in advance!

Best!