Which formula to use

Question

Hello,
&nbsp;
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.
&nbsp;
Can anyone tell me which formula would work for this?
&nbsp;
Below my file:
&nbsp;

Shift
Ordernumber
line
Material&nbsp;
Quantity
Plan(hours)
Reality(hours)
Operator
Comments
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

1
1992620
10
1804
100
&nbsp;
&nbsp;
RH
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

1
1992621
20
1800
0
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

2
156461
20
1800
100
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
time per second
&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
1804
34.3
&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
1800
17.2
&nbsp;

&nbsp;

&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;

jkpieterse · Accepted Answer

=E2*VLOOKUP(D2,$L$5:$M$6,2,FALSE)

Forum Discussion

Which formula to use

2 Replies

Resources

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