INDEX

B

brianTmcnamara

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
 
R

Ron Rosenfeld

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.
Click to expand...

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.
Click to expand...

Probably depends on what you are trying to accomplish.


--ron
 
Top