| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to setup a hyperlink to an indirect function?
I have a formula;
=HYPERLINK(INDIRECT($A225&"!"&"$B$4"),INDIRECT($A2 25&"!"&"$B$4")) that is not working. It comes up with an error message "Cannot open specified file". Originally, the cell contained the following formula, but i'm trying to put a hyperlink over the top of it. =INDIRECT($A224&"!"&"$B$4") This indirect statement basically returns the data in workbook / cell '5'!B4. I want to be able to hyperlink to that. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
| hyperlink function | Excel Worksheet Functions | |||
Threaded Mode
