| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
INDIRECT.EXT help needed
I am currently using the INDIRECT.EXT function as follows:
=INDIRECT.EXT("'K:\Insurance Quotes\Quote Sheets\2005\[Quotes2005_"& $D12 &".xls]TDS'!$M$6") However, I NEED to replace the file path (K:\Insurance Quotes\Quote Sheets\2005\) in this formula. I have concatenated this in a cell and would like to use the cell reference as the path. I just don't know how to! Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom percent format needed | Excel Worksheet Functions | |||
| Problems with PULL function, INDIRECT.EXT and so forth | Excel Worksheet Functions | |||
| Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions | |||
| INDIRECT.EXT question | Excel Worksheet Functions | |||
| Problem with updating values with INDIRECT.EXT | Excel Worksheet Functions | |||
Threaded Mode
