Lookup ?

[ml0824]

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

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

 

[Richard Schollar]

Hi Mike

In E10 enter:

=VLOOKUP(A10,$H$10:$J$19,3,0)

and copy down.

Best regards

Richard