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

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

Cheers,
--
AP

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

In B5

=CHOOSE(variable_lead_time,C4,D4)

just extend as required

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"DtTall" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Long time no see!

"Ardus Petus" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...

Been busy getting paid for my developments!

"Bob Phillips" <(E-Mail Removed)> a écrit dans le message de news:
%(E-Mail Removed)...
> Long time no see!
>
> "Ardus Petus" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>
>