This is roughly what my table looks like:
A B C D E F Name |Ingredient 1 |Ingredient 2 |Ingredient 3 |Ingredient 4 |Ingredient 5 Dish 1 |flour |tomato |potato |eggs |wine Dish 2 |eggs |onion |capsicum |tomato |pasta Dish 3 |flour |eggs |dill |chicken |pork
What I want is to search for the ingredient, and get a result of all the dishes that contain that particular ingredient or even highlight the dish name. Each ingredient is in a different column and not in any sorted order. E.g. suppose I enter in another cell somewhere (or in another sheet) the word tomato, then all the dishes that contain that ingredient should show up. Is that possible with google sheets? This will be a constantly growing table.