Making a rollout schedule using offset and not nested IF!

Hi!

I am new and hope that someone can help me with my problem =).

I am trying to make a rollout schedule, whish is a plan for how many of X items to build pr Week. I have a list of milestones and their lead times. Please see the attached excel-file with example.Testing Offset.xls

I have defined the curve of the rollout graph in the ref. Milestone. I then use nested IF to get this schedule. In cell K8:
=IF($C8=0;K7;IF($C8=1;J7;IF($C8=2;I7;IF($C8=3;H7;IF($C8=4;G7;IF($C8=5;F7;S7))))))

This only works for up to 7 weeks of leadtime, which is the max number of nested IF. How can I use OFFSET to do the same?

Thanks a lot!