How to retain the web hyperlinks when doing a vlookup

I have got hyperlinked text values in a column in a worksheet - When I try to vlookup and get that values to another sheet in the workbook,the URL values are lost. I tried Xlookup and still the same result.

Used Hyperlink(Vlookup(.. - This brouht the values in blue underlined text but the link was to the folder in my machine where I have d