Fetching VLOOKUP value with embedded hyperlink

Reezky77 I have seen multiple requests for help on this subject - but none of the answers make sense! HELP! So allow me to restate challenge. I have spreadsheet "Documents" in which Cell A2 has document name WWWZZZ and Cell B2 has the link to where that document is saved such as https://wtweathers/wwwzzz. I have another spreadsheet "Process" that references document WWWZZZ and I want to add a column (Column Z) that will use VLOOKUP for "Documents" spreadsheet to populate the link in B2 to the "Process" spreadsheet in Column Z2. The vlookup formula shows the path in text, but will not allow a hyperlink and when I attempt to copy (to paste as URL), it only copies the vlookup formula. I am attempting to have the hyperlink in Documents B2 be displayed as a hyperlink in Process Z2. Anyone? Thanks!!!!