hello bob

sorry i used Q as a reference, it should really be this

=INDEX('J:\Sales Analyst\SWAT\Archieve 2011\P1W1\[Edmonton-Winnipeg.xls]Peter Vepstas'!$A$1:$X$63,I4,I5,1)

...the range is A1:X63

also,
I4 and I8 are rows and column reference, for when i was using the index formula.

im still getting the REF error.