Sorry I see the answer only today, I thought I would receive an email in case of a reply
Thanks a lot, this things is really helpful, but I have a problem, in this way i can search only in one cell, the one that the formula referes to
I need to search in a lot of cell because my goal is to create a diet with this excel file, so I have a database with all the food and the composition and than I have some tables for each day of diet in every day.
I can't search every time in the same celle because I need to add every food comoposition to the total.
Do you know how I can resove this things?
I tried with the combo box but it is too hard for me, I don't know how I can do it
I atached the file
I put your formula in the red cell (dieda!D4), but i need to searche in all the yellow cell because with the name of the food and the grams I can have the composition with the formula index/match
Thanks a lot!
Sincerely
Alessandro