Hi all,

In excel 03 I am using VLOOKUP to reverence a row (by the leading cells
text) from one worksheet to a larger all inclusive worksheet within the same
workbook.

The larger worksheet is being populated very well but I am not sure how to
get a cells hyperlink info to be referenced from the smaller to the larger
worksheet.

Is it possible to have the hyperlink information transferred using VLOOKUP?
I tried paste special formats but that just brings in the fonts, colors,
ect.

Here is the formula I am using. If possible do I just need to include
something here?
=VLOOKUP($A16,'Greg only'!$A$3:$AE$120,E$1,FALSE)

Thanks for any help
Take care