Try this, Peter:
=Hyperlink(=VLOOKUP(a1,B1:c20,2,FALSE))
************
Anne Troy
www.OfficeArticles.com

"Peter" wrote in message
...
I have a formlua =VLOOKUP(a1,B1:c20,2,FALSE), where the cell being looked
up
is a hyperlink. The formula return the correct path name for the
hyperlink,
but the cell displayed is no longer a hyperlink. Anybody know how to
retain
the hyperlink properties in these circumstances? Thanks
--
Peter
London, UK