Hyperlink based on cell value

[Cat129]

Hey Guys

I have a list of numbers in column A, and a folder with pdf's in.

The pdf's have the same file name (excluding extension) as the data in column A

I am trying to create a formula that will automatically hyperlink the pdf as currently someone is spending a stupid amount of time doing it manually at the end of each day.

I currently have

=HYPERLINK("[\\servername\Scanned Process Cards\]" & A1 & ".pdf",A1)

This opens the folder but not the file, no error messages so not sure where I have gone wrong.

Thanks,
Cat

 

[Cat129]

Figured it out, was being silly, just in case anyone needs this in the future

It should have been

=HYPERLINK("\\servername\Scanned Process Cards" & A1 & ".pdf",A1)

 

[Norie]

Cat

Why do you have [] around the path?

Try it without.

=HYPERLINK("\\servername\Scanned Process Cards" & A1 & ".pdf",A1)