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 |
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 |