Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use INDIRECT.EXT for this?
Here's the formula in question:
={INDEX('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$Q$500,SMALL(IF('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$B$500=$B$7,ROW('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$B$500)-2),ROW(1:1)),2)} Is it possible to replace the file name with a reference to a cell with the file name in it using INDIRECT.EXT? Do I need a cell in 20060918.xls with a CELL formula that holds the file name for INDORECT.EXT to reference? Any help would be greatly appreciated... Jay |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I use INDIRECT.EXT for this?
Forgive my density...
Does INDIRECT.EXT have to reference a cell in the 20060918.xls file that contains a =CELL(...) formula with the filename? "paul" wrote: yes.Indirect will let you use a list of file names as a reference to a file (or anything actually) in a formula.So you can day have a drop down list of all your files and when yoou select one your informaion is completed! -- paul remove nospam for email addy! "Jay Nichols" wrote: Here's the formula in question: ={INDEX('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$Q$500,SMALL(IF('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$B$500=$B$7,ROW('Z:\Mill Schedules Production\Mill Schedules Archive\[20060918.xls]Mill 1'!$B$3:$B$500)-2),ROW(1:1)),2)} Is it possible to replace the file name with a reference to a cell with the file name in it using INDIRECT.EXT? Do I need a cell in 20060918.xls with a CELL formula that holds the file name for INDORECT.EXT to reference? Any help would be greatly appreciated... Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT.EXT reference | Excel Discussion (Misc queries) | |||
INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
INDIRECT.EXT | Excel Discussion (Misc queries) | |||
INDIRECT.EXT | Excel Worksheet Functions | |||
INDIRECT.EXT help needed | Excel Worksheet Functions |