Let me explain, first off I pasted the wrong formula, it should hav
been:
=IF(AND(E$1=$B2,E$1<=$C2,$E$24=$AK$1,$AK$2="X",$E $34$E$25),$E$24,"")


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

Thanks

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