Change cell formula based on input in different cell
 

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

Change cell formula based on input in different cell
 

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

Change cell formula based on input in different cell
 

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" wrote in message
ps.com...
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

Change cell formula based on input in different cell
 

Long time no see!

"Ardus Petus" wrote in message
...

Change cell formula based on input in different cell
 

Been busy getting paid for my developments!

"Bob Phillips" a écrit dans le message de news:
...
Long time no see!

"Ardus Petus" wrote in message
...