Here is a somewhat unique issue. I am dealing with a variable lead
time on an item and the value entered can be 1, 2, 3...etc for how many
weeks.

The issue is that if the value is 1 then B5=C4. If the value is
changed to 2, then I want B5=D4 and so on. Is there anyway to do this?

Any help is much appreciated.

Thanks,
DtTall