Hi
you have to use absoulte references. That is insetad of
B1:B100
use $B$1:$B$100
as provided in my initial example

--
Regards
Frank Kabel
Frankfurt, Germany
schrieb im Newsbeitrag
ups.com...
Oh dear...You know what - and I knew I'd do it..in all my excitement, I
spoke to soon!
The formula is doing the right thing, but returning the wrong values...

I am asking it to seach for anything beginning/containing CL and
instead, it is returning me values starting with CF etc (and only some
of them...)?

If you copy the values in the list below into cells B5:B29 and then
paste the formula below the list into C1, you'll see what I mean...

CL_0015
CL_0021
CL_0022
CL_0025
CL_0028
CL_0029
CL_0030
CF_0002
CF_0003
CF_0008
CF_0009
CF_0019
CF_0027
CS_0034
CS_0038
EO_0002
FI_0001
FI_0002
FI_0012
FI_0013
IF_0009
NI_0001
NI_0007
NI_0008
NI_0009

{=IF(ISERROR(INDEX(B5:B29,SMALL(IF(ISNUMBER(SEARCH B("CL",B5:B29,1)),ROW(B5:B29)),ROW()))),"",(INDEX( B5:B29,SMALL(IF(ISNUMBER(SEARCHB("CL",B5:B29,1)),R OW(B5:B29)),ROW()))))}

No idea this time...but again, appreciate your genius here!
many thanks
Sue