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" <AWS@discussions.microsoft.com> wrote in message
> news:0E0A5514-E480-4F31-A245-55DBFFB2EB71@microsoft.com...
> >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?
>
>
>