Sorry - please ignore my note below..I must have been doing something
daft...it [formula below] now works...Thank you again!! you are a
saviour!

cheers
Sue


={IF(ISERROR(INDEX('Pivot
40%'!$B$5:$B$1000,SMALL(IF(ISNUMBER(SEARCHB("CL", 'Pivot
40%'!$B$5:$B$1000,1)),ROW('Pivot
40%'!$B$5:$B$1000)),ROW()))),"",(INDEX('Pivot
40%'!$B$5:$B$1000,SMALL(IF(ISNUMBER(SEARCHB("CL", 'Pivot
40%'!$B$5:$B$1000,1)),ROW('Pivot 40%'!$B$5:$B$1000)),ROW()))))}