Where to add another IF statement in this formula

[Kevin Stewart]

The formula below works great, but I need to add another IF statement to it. I Need something like.... IF(DATA!$Z$2:$Z$20000>=$H$2 But I don't know where to insert. I've tried it all ways that I know how and can't get it to work.



{=IF(ROWS(D$4:D4)<=$L$2,INDEX(DATA!B$2:B$6372,SMALL(IF(DATA!$A$2:$A$6372=$E$2,IF(DATA!$E$2:$E$6372=$G$2,ROW(DATA!$E$2:$E$6372)-ROW(DATA!$E$2)+1)),ROWS($D$4:D4))),"")}

[AlKey]

Maybe this?

=IF(Data!$Z$2:$Z$20000>=$H$2,IF(ROWS(D$4:D4)<=$L$2,INDEX(Data!B$2:B$6372,SMALL(IF(Data!$A$2:$A$6372=$E$2,IF(Data!$E$2:$E$6372=$G$2,ROW(Data!$E$2:$E$6372)-ROW(Data!$E$2)+1)),ROWS($D$4:D4))),""))

[Kevin Stewart]

Thanks, but it still just pulls the first items and looks past the >=H2 statement

[AlKey]

One more

=IF(AND(ROWS(D$4:D4)<=$L$2,Data!$Z$2:$Z$20000>=$H$2),INDEX(Data!B$2:B$6372,SMALL(IF(Data!$A$2:$A$6372=$E$2,IF(Data!$E$2:$E$6372=$G$2,ROW(Data!$E$2:$E$6372)-ROW(Data!$E$2)+1)),ROWS($D$4:D4))),"")

[FDibbins]

This looks very much like this thread, which has already had a few suggestions (mine included)...
http://www.excelforum.com/excel-form...step-away.html

Please do not post duplicate threads.

I and going to close this thread now, you can continue on your other thread. If this is not the same thing, please PM me to let me know how it is different and I will re-open this thread