Im trying to come up with a way to do a recipe card. I would like col A's selection to lookup in col H and put the correct cost from col J in E
For example, E10 would be .115625.
Any help is appreciated and if you have a better way of doing this I would like to hear it. Thanks in advance, Mike
For example, E10 would be .115625.
Any help is appreciated and if you have a better way of doing this I would like to hear it. Thanks in advance, Mike
standard recipe card.xls | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
9 | INGREDIENTS | AMOUNT | UNITS | UNIT COST | TOTAL COST | Ingredients | Unit | Oz | ||||
10 | Chix Cutlets | 12 | oz | 0 | Bread Crumbs | 3.85 | 0.048125 | |||||
11 | Bread Crumbs | 2.5 | oz | 0 | Cheese | 1.75 | 0.109375 | |||||
12 | Egg wash | 1 | oz | 0 | Chix Cutlets | 1.85 | 0.115625 | |||||
13 | Marinara Sauce | 4 | oz | 0 | Egg wash | 0.02 | ||||||
14 | Cheese | 6 | oz | 0 | Eggplant | |||||||
15 | Marinara Sauce | 3.25 | 0.025391 | |||||||||
16 | TOTALS | Meat Sauce | ||||||||||
17 | Pork Chop 8 oz | |||||||||||
18 | Shrimp 16/20 | |||||||||||
19 | Veal Cutlet | |||||||||||
Sheet1 |