That worked great Trevor! It assigns the task exactly where it should,
had to change the formula slightly to:

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

But let me ask you this, how would I go about advancing to the othe
tasks I need to assign? Is there a way to have the formula change t
the next tasks label after the first task is satisfied. I could line u
all of the tasks reuired and loop through each?



Or would that be too difficult?

Thanks so much for your help

Attachment filename: trevorschedule.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=51419
--
Message posted from http://www.ExcelForum.com