Recipe Costing Project
Budget: $30 – $250 USD
Hello,
I need assistance in determining how to create a complex Excel formula. My worksheet has a reference sheet called "pricing list," where I manually populate ingredient names, units of measure, measurement name, and cost per unit of measure.
In a second tab, called "recipe profit," I would like to be able to calculate how much a certain ingredient quantity costs specifically for that recipe.
Example from Sheet 1 (pricing list):
Ingredient: AP Flour
Price: $3.79
Unit of measure: Pounds
Measurement quantity included in price: 4
Goal: In Sheet 2 (recipe profit), I'd like to create a formula that grabs the ingredient name, measurement reference name, and multiplies cost of a single unit of that same measurement per the price list multiplied by the total number of units required for the recipe.
I am currently able to achieve this by using a VLOOKUP formula, however that formula needs to be updated based on the unit of measure required in the recipe that is called out in its own row. I'd like to create a formula that is automated, regardless of the unit of measure or the ingredient name.
Thank you,
Kelli
Thank you,
Kelli
I need assistance in determining how to create a complex Excel formula. My worksheet has a reference sheet called "pricing list," where I manually populate ingredient names, units of measure, measurement name, and cost per unit of measure.
In a second tab, called "recipe profit," I would like to be able to calculate how much a certain ingredient quantity costs specifically for that recipe.
Example from Sheet 1 (pricing list):
Ingredient: AP Flour
Price: $3.79
Unit of measure: Pounds
Measurement quantity included in price: 4
Goal: In Sheet 2 (recipe profit), I'd like to create a formula that grabs the ingredient name, measurement reference name, and multiplies cost of a single unit of that same measurement per the price list multiplied by the total number of units required for the recipe.
I am currently able to achieve this by using a VLOOKUP formula, however that formula needs to be updated based on the unit of measure required in the recipe that is called out in its own row. I'd like to create a formula that is automated, regardless of the unit of measure or the ingredient name.
Thank you,
Kelli
Thank you,
Kelli