| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink function
=HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!
R1:AP4,2,FALSE))),"PRESS TO SELECT") This revision of the above worked fine over he =HYPERLINK("#"&CELL("address",INDIRECT(C5&HLOOKUP( C3,Master!R1:AP4,2,FALSE))),"PRESS TO SELECT") -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Larry" wrote: I am trying to use a hyperlink to go to a named range depending upon the values of two cells concatenated together. Here is what have. =HYPERLINK((CONCATENATE(C5,HLOOKUP(C3,master!R1:AP 4,2,FALSE))),"PRESS TO SELECT") The lookup is necessary because of varying values. This returns the proper named range but when I click on it it says "Cannot open specified file". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
| HYPERLINK function | Excel Discussion (Misc queries) | |||
| How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
| Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
| hyperlink function | Excel Worksheet Functions | |||
Hybrid Mode
