| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use indirect function?
Does anyone have any suggestions on how to use Indirect function to retrieve
the value 2318 from cell A1 for following formula in cell B1 ='C:\folder\2318\[file.xls]sheet'!M$15 in cell B1 Thanks in advance for any suggestions Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use indirect function?
=INDIRECT(B1)
To make sure that the string in B1 is correct put a = before it... once it returns the value in the cell it refers to... delete = and use the INDIRECT formula "Eric" wrote: Does anyone have any suggestions on how to use Indirect function to retrieve the value 2318 from cell A1 for following formula in cell B1 ='C:\folder\2318\[file.xls]sheet'!M$15 in cell B1 Thanks in advance for any suggestions Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to use indirect function?
INDIRECT won't work to retrieve stuff from closed books, which is what you're
trying to do. I'd just try using a couple of Edit Replaces to change the link formulas en-masse. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "Eric" wrote: Does anyone have any suggestions on how to use Indirect function to retrieve the value 2318 from cell A1 for following formula in cell B1 ='C:\folder\2318\[file.xls]sheet'!M$15 in cell B1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Indirect function help please | Excel Worksheet Functions | |||
| INDIRECT function | Excel Worksheet Functions | |||
| Indirect Function | Excel Worksheet Functions | |||
| INDIRECT function inside AND function | Excel Worksheet Functions | |||
| Using the Indirect.Ext function | Excel Worksheet Functions | |||
Hybrid Mode
