Assuming your input cell is A1, enter in B5:
=OFFSET(B4,0,A1)

Cheers,
--
AP

"DtTall" a écrit dans le message de news:
...
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