Hi,
I'm making food cost calculations and would like to make my life more simple.
I have one sheet with the list of ingredients and their prices:
Screen Shot 2015-09-12 at 4.34.58 pm.png
On another sheet I have a pull-down of those ingredients and would like the cost (Column G)
to be calculated automatically based on the prices above, when I enter the weight in Column E
Screen Shot 2015-09-12 at 4.35.53 pm.png
Any Advice?
Bookmarks