2020-12-29

Input Value on another table only when necessary

I have another excel problem. What function do I need to display only a lead time when there is an order placed? For this example, the 3rd Lead Time RN "0.19" will be displayed on Week 7 of the first table. Can you please help me again. Thanks a lot.

My formula for the Lead Time column on the first table so far is:

=IF(I9=6,Q20,"")

But then again, I only want to display the next Lead Time RN on weeks in which an order is placed.

Table 1 picture enter image description here

enter image description here Table 2 picture



from Recent Questions - Stack Overflow https://ift.tt/3pqthEb
https://ift.tt/3nXdLPU

No comments:

Post a Comment