Hi!

I'm currently running a restaurant and we do the recipe costings manually. We're re-doing the entire menu and so we have to do the costing over again as well. I've already created a worksheet for the unit prices of each ingredient and another worksheet for the recipes. I'd like to be able to link the recipes to the price list so that i won't have to link each ingredient to it's price per recipe. I have over 60 recipes and it's very tiresome to do them one by one. is there a way to do this? perhaps a formula. i've tried vlookup, but i can't seem to figure out how to make the formula.

help?


thanks!


selie