Hyperlink after Vlookup

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.

Check the attachment

I am unable to download the file. Can you please upload in google drive or something.

Enter this formula in B6 and copy in the cells below

=IFERROR(HYPERLINK("#'Risks-Description'!H"&MATCH(C6,'Risks-Description'!$B:$B,0),C6),"")