That does the job, nice one cheers

"Anne Troy" wrote:

I'm pretty sure you can just put =hyperlink(yourformulahere)
************
Anne Troy
www.OfficeArticles.com

"AWS" wrote in message
...
I have a formula:-

=IF(ISERROR(VLOOKUP(H62,DCRnames,3,FALSE)&F62),"
",VLOOKUP(H62,DCRnames,3,FALSE)&F62)

The result ends up with a web page url, is it possible to make the result
a
clickable hyperlink?