vlookup hyperlink

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?

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?

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?
>
>
>