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.