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[TABLE="width: 955"]
<tbody>[TR]
[TD="class: xl65, width: 955"]Ltr.no-01-18.06.2018-KNR-PD-Conditions Precedent pursuant to Article 4 of EPC Agreement.pdf[/TD]
[/TR]
</tbody>[/TABLE]
D2=[TABLE="width: 306"]
<tbody>[TR]
[TD]Lr No.KNRSPPL/NH-161/HO/NHAI/PD/2018/01[/TD]
[/TR]
[TR]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 1055"]
<tbody>[TR]
[TD]SI No[/TD]
[TD]Letter No[/TD]
[TD]Date[/TD]
[TD]Subject[/TD]
[TD]Reference[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Lr No.KNRSPPL/NH-161/HO/NHAI/PD/2018/01[/TD]
[TD]18/6/2018[/TD]
[TD]Conditions Precedent pursuant to Article 4 of the Concession Agreement[/TD]
[TD]1. Concession Agreement dated 09.05.2018
[/TD]
[/TR]
[TR]
[TD]2. KNR Constructions Limited Lr. No. Nil
dt.06.04.2018[/TD]
[/TR]
[TR]
[TD]3. PD, NHAI Lr. No. NHAI/PlU-SR/NH-161/S-N-
A/Package-II/GC/2018/216 dt.12.04.2018[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Lr No.KNRSPPL/NHAI/PD/02[/TD]
[TD]6/7/2018[/TD]
[TD]Traffic Surveys including Classified traffic Volume Count, Turning Movement , Axle Load Surveys and Test Pits and other investigations on the Project Highway[/TD]
[TD]1. Concession Agreement dated 09.05.2018[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Lr No.KNRSPPL/NHAI/PD/02A[/TD]
[TD]28/7/2018[/TD]
[TD]Review Meeting dt 12-07-2018-ISSUES[/TD]
[TD]1. PD, NHAI Lr. No. NHAI/PIU-SR/NH-161/S-N-A
/Package-II/GC/2018/340 dt.16.07.2018[/TD]
[/TR]
</tbody>[/TABLE]
THIS Yellow color cells have individual cells iam unable to Drag properly