Hi
I have made a nutrition price and nutrients table in Calc – see attached.
Nutrition.ods
Now I want to be able to just fill in the grams and what food I plan to eat in a day in another column (yellow area), and do so for other food in the rows below, and would like calc to detect the food item in the table left hand and get me the required data into the green area.
I would be happy if someone could attach a solution for this together with a description.
Greetings, Klaus