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$3 4$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 E25:P25, The correspondin
values that shopuld be returned are in E24:P24

I can't get it to work!

Thanks
Ji

--
Message posted from http://www.ExcelForum.com