how to add friendlynames to hyperlinks

[bhandari]

i have tried using Hyperlink formula but it is not opening specified path
=hyperlink(A2,B2)

There are around 200 cells i have to give friendly names to open specific file any idea how to do this

Thanks for reading my post

 

[mole999]

what is represented in A2 and B2 exactly

 

[bhandari]

C2=HIDED

Ltr.no-01-18.06.2018-KNR-PD-Conditions Precedent pursuant to Article 4 of EPC Agreement.pdf

<tbody>
</tbody>

D2=

Lr No.KNRSPPL/NH-161/HO/NHAI/PD/2018/01

<tbody>
</tbody>

if i click direct C2 it will open my pdf from folder path i want to open with D2



All columns have different merged cells iam unable to drag i have to give manually

EX:

SI No	Letter No	Date	Subject	Reference
1	Lr No.KNRSPPL/NH-161/HO/NHAI/PD/2018/01	18/6/2018	Conditions Precedent pursuant to Article 4 of the Concession Agreement	1. Concession Agreement dated 09.05.2018
2. KNR Constructions Limited Lr. No. Nil dt.06.04.2018
3. PD, NHAI Lr. No. NHAI/PlU-SR/NH-161/S-N- A/Package-II/GC/2018/216 dt.12.04.2018
2	Lr No.KNRSPPL/NHAI/PD/02	6/7/2018	Traffic Surveys including Classified traffic Volume Count, Turning Movement , Axle Load Surveys and Test Pits and other investigations on the Project Highway	1. Concession Agreement dated 09.05.2018
3	Lr No.KNRSPPL/NHAI/PD/02A	28/7/2018	Review Meeting dt 12-07-2018-ISSUES	1. PD, NHAI Lr. No. NHAI/PIU-SR/NH-161/S-N-A /Package-II/GC/2018/340 dt.16.07.2018

<tbody>
</tbody>

THIS Yellow color cells have individual cells iam unable to Drag properly