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.