Hi guys,
Anyone got any ideas of how I can write the following in a shorter way so
that I can include more refences I.E. more of:
IF(('[CT 00-07.xls]Writing'!$E$10:$E$89="Female")*('[CT
00-07.xls]Writing'!$AC$10:$AC$89=BK12),'[CT 00-07.xls]Writing'!$BB$10:$BB$89),

Any more than shown below will be beyond the formula length limit. OR is
there a way of extending the formula length limit!!!???

FORMULA AS IT IS AT PRESENT:

=VLOOKUP(ROUND(AVERAGE(IF(('[CT
00-07.xls]Writing'!$E$10:$E$89="Female")*('[CT
00-07.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
00-07.xls]Writing'!$BB$10:$BB$89),IF(('[CT
01-08.xls]Writing'!$E$10:$E$89="Female")*('[CT
01-08.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
01-08.xls]Writing'!$BB$10:$BB$89),IF(('[CT
02-09.xls]Writing'!$E$10:$E$89="Female")*('[CT
02-09.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
02-09.xls]Writing'!$BB$10:$BB$89),IF(('[CT
03-10.xls]Writing'!$E$10:$E$89="Female")*('[CT
03-10.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
03-10.xls]Writing'!$BB$10:$BB$89),IF(('[CT
04-11.xls]Writing'!$E$10:$E$89="Female")*('[CT
04-11.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
04-11.xls]Writing'!$BB$10:$BB$89),IF(('[CT
05-12.xls]Writing'!$E$10:$E$89="Female")*('[CT
05-12.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
05-12.xls]Writing'!$BB$10:$BB$89),IF(('[CT
06-13.xls]Writing'!$E$10:$E$89="Female")*('[CT
06-13.xls]Writing'!$AC$10:$AC$89=BK12),'[CT
06-13.xls]Writing'!$BB$10:$BB$89)),0),APS!$B$3:$C$39,2,FALSE )

Thanks
RR1