Formula for Hyperlink to files depending on name from the sheet

[noare]

Good day,

I've got a sheet for certification of tools, I would like to set a formula for hyperlink pdf certificates to the cells in column H from folder with pdf files that have names like in column E, but leave names as was set in column H.
i just can hyperlink the file or folder with formula, but not set the rule for automatic connection of links.
excel question.jpg

[Estevaoba]

Try this formula in column H:
=HYPERLINK("C:\Users\noare\Documents\"&E4&".pdf",H4)

Change "C:\Users\noare\Documents\" to the correct path to your file.
Change E4 to correct cell with pdf file name in column E.
Change H4 to correct cell with desired hyperlink name in column H.

Good luck!