Copy hyperlink in another sheet when using vlookup [Closed]

Registration date
Thursday July 27, 2017
Last seen
August 29, 2017
Hello guya please help.

I have little knowledge in vba.

i have an employee details in sheet 1 and i have a vlookup fromula in sheet 2 to show the id number, visa number and passport number.

The id number, visa number and passport number are in hyperlinks that show the jpg file of the id, visa and passport.

Is there a vba code that when i use the vlookup formula in sheet 2, the id, visa and passport numbe will appear in hyperlink which also shows the jpg file just like in sheet 1?

Please help.

Thank you