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.
