Hi all,

I'm trying to create a Cook Book on excel. The ultimate goal of the excel document is to be able to search for a recipe based off certain ingredients; so if you have tomatoes, you would be able to search for all ingredients that have tomatoes in them.

Essentially, I want to be able to type in "x" amount of ingredients and select a radio button that describes a type of meal (such as breakfast, lunch, dinner, etc.). After you fill in those two criteria, you would press the "Search" button and it would execute the search.

To clarify, in cell 9, 12, 15, and 18, one would write the ingredient(s) that they want to search for, and then they would proceed to select the radio button that describes the type of meal (breakfast, lunch, dinner, etc.)

Does anyone have any ideas how to do this? I've been stuck on this for a long time and have no idea where to go. Thank you!