Hyperlink after Vlookup

[bagadiamohit]

This simple thing is eating my brain out. Here is the challenge:

I have 2 sheets in the same workbook. Say Sheet 1 and Sheet 2. I want to Vlookup for the value present in Sheet 1 Column A and Sheet 2 column B. If the value is found i want to put a hyperlink in Sheet 1 Column A to point it to Sheet 2 Column D. In simple words, there are program names present in both the sheets and associated risk in sheet 2. If the program is present in both the sheets then i want to navigate directly to the risk present in the Sheet 2 upon clicking the program name in Sheet1.

I am attaching the sample file with this thread. Please somebody help me. I have tried with vba and normal formulas. Nothing is being worked out.

SAmple file can be downloaded from here.

 

[bagadiamohit]

Guys, please ignore the above link. Here is the latest one.

https://drive.google.com/open?id=0B-Mgxdw-FueaVnBmLXBWZmZGVjA&authuser=0