The =vlookup() portion returns what's in the cell.

If the cell contains: www.microsoft.com

Maybe all you need to add is:
=hyperlink("http://" & vlookup(a1,b1:c20,2,false))

if it's an email address:
=hyperlink("mailto:" & vlookup(...))



Peter wrote:

Anne. I tried this without the 2nd =. While the result is a hyperlink, I get
the error message "can open the specified file" - although I know there's
nothing wrong with the original hyperlink. Any ideas? Thanks again.
--
Peter
London, UK

"Anne Troy" wrote:

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




--

Dave Peterson