Just to add on a little to Dave's good idea ..
.. Maybe =index() would would work for you.

Instead of:
=IF(ISNA(MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)-1),"",OFFSET('[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$C$140,,MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)-1))

Try something like:
=IF(ISNA(MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)),"",INDEX('[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$140,,MATCH($D$2-1,'[BOOKINGS.xls]NOV 2005 - JUNE
2006'!$C$2:$IJ$2,0)))

Above is untested but think it should work ok ..

The changes:
1. Removed the extraneous "-1" bit from within the: ISNA(MATCH(...)-1)
(overlooked this earlier, sorry)

2. Amended the OFFSET to suit INDEX, viz.:
a. Indexed range is $C$2:$IJ$140 (changed from the OFFSET's $C$2:$C$140)
b. Adjusted OFFSET's "MATCH(...)-1" part, i.e. removed the arithmetic "-1"
adjustment from "MATCH(...)-1" which is not required in
INDEX(...,,MATCH(...))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---