=INDEX([New orders 2001.xls]Jan! .... ,1,7)

Put array reference in place of ...
e.g. if your array is A1:G1 in sheet Jan in workbook New orders 2001.xls,
then =INDEX([New orders 2001.xls]Jan!A1:G1,1,7) returns the content of G1
(because it is the 7th column in row 1.

Regards,
Stefi

€žGinger€� ezt Ã*rta:

Hello all,

I seem to be becoming a bit of a regular here. Thanks to everyone who has
helped me so far!

Just a quick one this time. I am trying to use INDEX to get to a named array
in a different workbook. Having found that I get a #N/A message I have
started to wonder whether this is actually possible. The formula I am using
is:

=INDEX('New orders 2001.xls'!Jan,1,7)

I had thought that the file name needed to be in square brackets and the
name of the array including between the single quotes like so:

=INDEX('[New orders 2001.xls]!Jan',1,7)

But it would not accept this as a correct formula.

I bet it is something stupid so if you can see what it is please let me know!

Thanks again.