How to calculate recipe of ingredient stock

SokhaKH · Jun 12, 2019

Finish Product code	Finish Item	Qty
2001	Burger	2
2002	Caffe tea	3

Finish Product Code	Raw Material Code	Raw material item	Qty	Sub Qty
2001	1001	Salat	0.2	?
2001	1002	Sugar	1	?
2002	1003	Caffe	0.7	?
2002	1001	Water	0.9	?
2002	1003	Tea	0.2	?

MY question: How to calculate Sub Qty for Raw material?

kweaver · Jun 13, 2019

What should the Sub Qty ? be? Is the first one 2*0.2 and the second one 2*1

Finish Product Code	Finish Item	Qty	Finish Product Code	Raw Material Code	Raw material Item	Qty	Sub Qty
2001	Burger	2	2001			0.2	2
2002	Caffe tea	3	2001			1	2
			2002			0.7	2.1
			2002			0.2	0.6
			2002

Where Sub Qty is:

Code:

=VLOOKUP(E2,$A$2:$C$3,3,FALSE)

Because I have the right array "Finish Product Code" in E column and the Qty in the left array in the C (third) column and
the Qty in the right array in the H column.

kweaver · Jun 13, 2019

Excel 2010

A

B

C

D

E

F

G

H

I

1

Finish Product Code

Finish Item

Qty

Finish Product Code

Raw Material Code

Raw material Item

Qty

Sub Qty

2

2001

Burger

2

2001

0.2

2

3

2002

Caffe tea

3

2001

1

2

4

2002

0.7

2.1

5

2002

0.2

0.6

6

2002

Sheet3

Cell Formulas
Range	Formula
I2	=VLOOKUP(E2,$A$2:$C$3,3,FALSE)

SokhaKH · Jun 13, 2019

Thanks all my problem solved with this formula [FONT=&quot]=IFERROR(VLOOKUP(V5, $N$5:$O$18, 2, 0) * Z5, "")[/FONT]

How to calculate recipe of ingredient stock

SokhaKH

New Member

Excel Facts

kweaver

Well-known Member

kweaver

Well-known Member

SokhaKH

New Member

Similar threads

Forum statistics

Share this page

How to calculate recipe of ingredient stock

SokhaKH

New Member

Excel Facts

kweaver

Well-known Member

kweaver

Well-known Member

SokhaKH

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock