My Task is to Summarize the Ingredients By Categories. I have two Worksheets/Tables. The First lists the Categories and their respective Recipes
CategoryRecipe
<tbody>
</tbody>
Next is the Recipe x Ingedient Table
RecipeIngredient
<tbody>
</tbody>
I need a table:
CategoryIngredient on a 3rd sheet
<tbody>
</tbody>
I know this involves usings SUMIFS, LOOKUP, and possibly LEN since the Ingredients values are not numeric, but I'm really having trouble getting anywhere close to what I need from the examples of all those functions so any assistance would be greatly appreciated.
CategoryRecipe
Category (A) | Recipe (B) |
Cat1 | RecA |
Cat1 | RecB |
Cat2 | RecD |
Cat2 | RecC |
Cat3 | RecA |
Cat3 | RecD |
<tbody>
</tbody>
Next is the Recipe x Ingedient Table
RecipeIngredient
Recipe (A) | Ing1 (B) | Ing2 (C) | Ing3 (D) | Ing4 (E) |
RecA | X | X | ||
RecB | X | X | ||
RecC | X | X | ||
RecD | X | X |
<tbody>
</tbody>
I need a table:
CategoryIngredient on a 3rd sheet
Category | Ing1 | Ing2 | Ing3 | Ing4 |
Category 1 | ||||
Category 2 | ||||
Category 3 |
<tbody>
</tbody>
I know this involves usings SUMIFS, LOOKUP, and possibly LEN since the Ingredients values are not numeric, but I'm really having trouble getting anywhere close to what I need from the examples of all those functions so any assistance would be greatly appreciated.