SOLVED

Which formula to use

Copper Contributor

Hello,

 

I am looking for a formula but I don't know which one to use.

What I would like to do is that when in collum material is entered 1804 that it multiplies the collum quantity with 34,3. And the result is shown in collum plan(hours). But if in collum material is entered 1800 that then it is multiplied with 17,2 and collum quantity and result again is shown in collum plan(hours). File is in the attatchment.

 

Can anyone tell me which formula would work for this?

 

Below my file:

 

Shift Ordernumber line Material  Quantity Plan(hours) Reality(hours) Operator Comments          
1 1992620 10 1804 100     RH            
1 1992621 20 1800 0                  
2 156461 20 1800 100               time per second  
                      1804 34.3  
                      1800 17.2  

 

                         
2 Replies
best response confirmed by Ramon Haagen (Copper Contributor)
Solution
=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)

Works like a charm thanks!

1 best response

Accepted Solutions
best response confirmed by Ramon Haagen (Copper Contributor)
Solution
=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)

View solution in original post