Hi everyone.
I would like to use Excel to help me identify what cocktails I can make based on the ingredients I have on hand. I can easily hand enter the list of cocktails with ingredients, and I can create drop down menus to assert Yes/No for each ingredient that may exist in a recipe. However, I can't figure out how to make Excel return the list of all cocktails that have a "Yes" answer to each of their ingredients.

Is this even a task for Excel? I am experienced with macros, but I cant seem to see what logic is required to make this happen. Anyone have an idea which general direction to head? Ideally, I would like to simply answer Yes/No in drop downs to each possible ingredient and see what I am able to make.

Thanks!