Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX
why doesn't INDEX work across multiple worksheets? If I
INDEX('247695:446068'!D5,1,1) where 247695 and 446068 are worksheet names, "#VALUE" is returned. Any insight into how to get this work? Thanks. -brian |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDEX
On Tue, 24 Jan 2006 13:35:04 -0800, "brianTmcnamara"
wrote: why doesn't INDEX work across multiple worksheets? If I INDEX('247695:446068'!D5,1,1) where 247695 and 446068 are worksheet names, "#VALUE" is returned. INDEX is not one of the functions listed that can be used with a 3D reference. AVERAGE AVERAGEA COUNT COUNTA MAX MAXA MIN MINA PRODUCT STDEV STDEVA STDEVP STDEVPA SUM VAR VARA VARP VARPA Any insight into how to get this work? Thanks. Probably depends on what you are trying to accomplish. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to automatically number an index column | Excel Worksheet Functions | |||
Formatting result of Index function | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel | |||
Min formula not returning value from Index | Excel Worksheet Functions | |||
index to a range of cells | Excel Worksheet Functions |