software

why doesn't INDEX work across multiple worksheets? If I
INDEX('247695:446068'!D5,1,1) where 247695 and 446068 are worksheet names,
quot;#VALUEquot; is returned. Any insight into how to get this work? Thanks.

-brian

On Tue, 24 Jan 2006 13:35:04 -0800, quot;brianTmcnamaraquot;
gt; wrote:

gt;why doesn't INDEX work across multiple worksheets? If I
gt;INDEX('247695:446068'!D5,1,1) where 247695 and 446068 are worksheet names,
gt;quot;#VALUEquot; 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

gt;Any insight into how to get this work? Thanks.
gt;

Probably depends on what you are trying to accomplish.--ron