A friend suggested this solution which suited me just fine:
Column A | Column B
Dish | Ingredient
French Toast | Eggs
French Toast | Bread
French Toast | Butter
Pancakes | Eggs
Pancakes | Flour
Pancakes | Sugar
Hollandaise Sauce | Eggs
Hollandaise Sauce | Butter
Hollandaise Sauce | Lemon
Then filter on the ingredient.
I pretty much taught myself how to use Excel, to there are huge gaps in my knowledge--including this probably obvious solution.
Thank you all for putting up with my ignorance.