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

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

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