3 range criteria for Loop
 

I'm trying to populate a work schedule with different tasks, If a
employee A2 is working in a time range E1:EI1 (Time of Day) with
start time B2 and an end Time C2 that is within the Time of Day Range

And a task is required E34 E25

And the employee can do the task AK2 = "X"

Then the cell in the loop range should = E24 (The task name)

Then loop this for each employee in range A1:A100


The actual formula that works looks like this :

=IF(AND(E$1=$B2,E$1<=$C2,$E$24=$AK$1,$AK$2="X",$E $34$E$25),$E$24,""


It works but I don't know how to apply through all of the cells in
loop


Thanks

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