Hello. My desired task is as follows.

1. I have an excel sheet with names of documents (E.g. WPS1, WPS2, WPS3 and so on). This excel sheet is stored in shared drive in BOX.

2. I have another shared BOX folder with the pdf of the documents. (E.g. WPS1.pdf, WPS2.pdf, WPS3.pdf and so on).

3. I want to prepare a clickable link in excel sheet so that it opens the pdf in shared drive.

Please help.