Several Vlookups from drop downs needing to add results in each cell

[Darkesy]

So my spreadsheet has 7 drop down boxes with 10 choices, they all have the same choices which are Meal Choices, the ingredients are listed left to right in a table on a different sheet. This is to generate a complete ingredient list in a table of ingredients (already created) for all 7 drop down choices.

I have created Vlookups for every ingredient in the table so that I can return a value for choice 1 into each ingredients cell but I want to be able to create Vlookups for the other 6 drop downs and then if they are returning a value to the same cell (ingredient) add the results together (e.g. 4 potatoes plus 5 potatoes = 9)

This is twisting my melon!!

 

[Marcílio_Lobão]

Darkesy, Good morning.

I do not know if I have fully understood your doubt.

Initially it seems that the issue can be solved with the Function COUNTIF.

However, the layout of your spreadsheet can radically change the way you resolve the doubt.

Save your spreadsheet at a free website, www.sendspace.com and place the link here for download.
Remember to manually type at least one example with the expected response.

I'm sure there will be colleagues willing to help.