Hi All,

I saw this from 1 of the worksheet. Could someone explain it to me??

=IF(ISERROR(INDEX('S:\[JOBLIST-2005.xls]JOBLIST'!$A$1:$E$10000,SMALL(IF('S:\[JOBLIST-2005.xls]JOBLIST'!$O$6:$O$10000='CBU LC'!DI$1,ROW('S:\[JOBLIST-2005.xls]JOBLIST'!$A$6:$O$10000)),ROW(1:1)),5)),"",INDEX('S:\[JOBLIST-2005.xls]JOBLIST'!$A$1:$E$10000,SMALL(IF('S:\[JOBLIST-2005.xls]JOBLIST'!$O$6:$O$10000='CBU LC'!DI$1,ROW('S:\[JOBLIST-2005.xls]JOBLIST'!$A$6:$O$10000)),ROW(1:1)),5))