Display the link of the file from fixed folder when the file is selected from drop down

Hi all,

Kindly do through the excel file that i have attached.

All the explanations are given in the excel for better understanding.

I have a folder named Trial which contains a excel file and many reports.
There are two kinds of reports, they are Report 1 and Report 2.
There are two kinds of parts C1&C2. So the reports are saved as C1-Report1, C1-Report2 etc.
Aim:
In the excel file, when i select C1 from drop dowm, the link for the two files should be displayed. So when i click the link the corresponding file should be opened which is in folder Trial
When i change the selection to D1, respective report should be available as a link.
Note
I don't want to manually link the document.

I myself solved it.
i used =hyperlink("C:\Users\Vignesh\Trial\"&[Cell]&".[filetype]")