ExcelBanter - vlookup hyperlink

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - vlookup hyperlink (https://www.excelbanter.com/excel-discussion-misc-queries/46158-vlookup-hyperlink.html)

AWS

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?

Anne Troy

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?

AWS

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?

All times are GMT +1. The time now is 07:04 PM.