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!
Bookmarks