Hyperlinking Help with Excel

[conwaythibodeaux]

I am working on a Excel Database. In a folder, directory, that contains the spreadsheet also contains a lot of .PDF files. On the spread sheet, column A contains part or the file name. In column O, I want a Hyperlink to say Click Here For PDF.

This is what I have so far, and it works perfectly if the name is exact.
=HYPERLINK(".\"&A3&".pdf","Click Here For PDF")

However not all of my files are named exactly as referred to in column A. Sometimes what is typed in column a is at the beginning, sometimes it is in the middle, and sometimes it is at the end.

At the moment, I currently have 65 rows to do this for with more to add.

[AliGW]

Provide some representative sample data, otherwise we have very little chance of helping you effectively.

[conwaythibodeaux]

Sorry,
Attached is a screenshot of what my spreadsheet looks like. See image screenshot excel. O3's hyperlink works perfectly using =HYPERLINK(".\"&A3&".pdf","Click Here For PDF") as my filename is exact. however the rest does not.

Also attached is a screenshot of sample folder with some PDF file named that I would like to open when I click the hyperlink.