multiple looping criteria

[hotherps]

I would like to try and loop the following formula through a set range
IF(AND(D$1>=$B2,D$1<=$C2,$E$24=$AK$1,$AK2="X",$E$34>$E$25),$E$24,"")

If the formula results True then the value in E24 is placed there.
want the formula to do this until cell E25 = 0.

Then I would like to move to the next cell in the range and use F24 a
the value returned and place that value until F25 = 0 and so on...

The range of cells that have the criteria is E2525, The correspondin
values that shopuld be returned are in E2424

I can't get it to work!

Thanks
Ji

 

[Tom Ogilvy]

If these conditions are not met you want to display ""
D$1>=$B2,D$1<=$C2,$AK2="X",

Then maybe something like this:

=IF(AND(D$1>=$B2,D$1<=$C2,$AK2="X")=FALSE,"",INDEX($A$24:$P$24,1,SMALL(IF(($
E$34>$E$25:$P$25)*($E$24:$P$24=$AK$1)*($E$25:$P$25<>0),COLUMN($E$24:$P$25)),
1)))

Entered with ctrl+shift+enter rather than just enter. Probably not what you
want, but maybe it will give you some idea of how you can achieve your
desired result.

 

[hotherps]

Thanks Tom, I'm going to sit down and give this a look. I've never eve
seen "Index" or "Small" before. I'll dig into it.

Thanks again
Ji