I have a table that includes an "inventory" item's name, as well as its base weight and associated carbs, protein, fat, etc. On another sheet, there's a table that references the inventory item's name, and once I input the actual weight, I'd like my other calculated columns to automatically figure out the carbs, protein, fat, etc. for that selected item and weight. For example...
My "inventory" sheet:
Item Amount Unit Calories Carbs Protein Fat
Chicken Thigh (w/ Bone) 1 oz 37 0 3.73 2.3
And my list of items eaten, sold, whichever: This is the rendered table
Item: Measure Unit Carbs Protein Fat
Chicken Thigh (w/ Bone) 4.6
And the raw formulas, or what I think they may be: I have no idea how to automatically select calories/carbs/etc to use for calculations :(
Item: Measure Unit ... Carbs ... Protein ... Fat
=Inventory.A2 4.6 =Sheet/Row of A2's E column * B2
...anyone know how to do this in excel? Is it even possible?
