Can I use Excel to Identify Cocktails based on my Ingredients?

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!

My logic would have a sheet with the cocktail name in column A.
In the same row list 1 ingredient per column until all are listed.

You could then create a form that has a listbox that is populated with all the ingredients of all cocktails.

Have a set of textboxes to display each selected ingredient from the listbox.

Then use a CASE statement to assess if all selected ingredients match a cocktails ingredients.