ExcelBanter - INDEX

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - INDEX (https://www.excelbanter.com/excel-worksheet-functions/67195-index.html)

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

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