| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP Limitations | Excel Worksheet Functions | |||
| Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
| DropDown with VLOOKUP & HYPERLINK | Excel Worksheet Functions | |||
| vlookup data hidden within worksheet | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
Linear Mode
