Using two criteria on two array in Index()

Hello,

I've become stuck on a recent project and need some help. I have the following formula:

{=INDEX(Sheet1!$A$2:$A$4000,SMALL(IF(Sheet1!$F$2:$F$4000<>1,ROW($2:$4000)-1,""),ROW(B3)-1))}

Quick summary; It looks at Sheet1, column F and as long as there isn't a 1 in there, it returns the corresponding value in column A, this happens for as far down as I pull the equation. The change to this that I'd like to make is look at column F, return true if the value isn't 1 AND look at column M and return true if Len()>3. I've tried the following equations:

{=INDEX(Sheet1!$A$2:$A$4000,SMALL(IF(AND(Sheet1!$F$2:$F$4000<>1,LEN(Sheet1!$M2:$M$4000)>3),ROW($2:$4000)-1,""),ROW(B3)-1))}

{=INDEX(Sheet1!$A$2:$A$4000,SMALL(IF(SUMPRODUCT(--(Sheet1!$F$2:$F$4000<>1),--(LEN(Sheet1!$M$2:$M$4000)>3)),ROW($2:$4000)-1,""),ROW(B3)-1))}

I believe the problem is, in the original formula, the IF(Sheet1!$F$2:$F$4000<>1, returns an array into the If statement. By adding AND() or Sumproduct() they return on a single value into the IF. Is there a way to force an array return, or maybe a better way of going about it in general.

weeble33,

Give this a try:

{=INDEX(Sheet1!$A$2:$A$4000,SMALL(IF(Sheet1!$F$2:$F$4000<>1,IF(LEN(Sheet1!$M$2:$M$4000)>3,ROW($2:$4000)-1)),ROW(B3)-1))}