Excel Hyperlink and Vlookup

Hello,

I have a hyperlink on one tab of a workbook. I need the link to copy to another page based on a key identifier. I have been using vlookup to move data to the front page for the rest of the fields, but the hyperlink has me stumped!

=VLOOKUP($C121,'Projected Wires'!$A:$R,18,FALSE) returns the link text...ish.