Hyperlink & Vlookup

Hello all, this is my first post and hopefully some kind soul will be able to help me.

I am currently using this formula to return a value from a cell.

=(VLOOKUP(A1,'Table 1'!A1:C143,2,FALSE))

In the referenced worksheet column, the cell contains a hyperlink to a document on a network drive as well as a value. Is there a way of copying the value and the hyperlink to the display page?

Thank you in advance.

Edit:-- I have also tried the =Hyperlink(VLOOKUP(A1,'Table 1'!A1:C143,2,FALSE))