How to copy hyperlink with formula

[ahmad08]

Hi experts,
I am working on a file where some data is picked from one sheet to other by using vlookup function. Hyperlinks are not being picked automatically in other sheet.
In Sheet 2
A1 consists of drop down list from Sheet 1 B5:B6.
In B3 below formula is used.
=VLOOKUP(A$1,Sheet1!B$4:G$6,ROWS(A$1:A6),0)
It is picking directly value from Sheet 1, B3, but it is not picking hyperlink along with value.
Same hyperlink is working in sheet1.
Please help how I can make hyperlink working in Sheet 2 as well.
Below is excel file link.
Copy Hyperlink with formula.xlsx - Google Drive

 

[Special-K99]

This works doesn't it?

=HYPERLINK(VLOOKUP(A$1,Sheet1!B$4:G$6,ROWS(A$1:A6),0))