Data validation list, created from a filtered table range/column

Hi

I've been struggling with this for a couple of days and don't think I'm going to crack it. Hoping someone can help me out. I'm trying to write a meal planner. I've attached a copy of the file I'm about to talk about.

On sheet Dishes I have Table 1, which contains a list of categories of dishes (Meat, Vegetable, Dessert) and what they are (Steak, Carrots, Ice Cream).

On sheet Planner I have Table 2, which has columns for Day, Meat, Vegetable 1, Vegetable 2, and Dessert.

I would like a drop down list in each of the food columns on Table 2, which looks through all of the matching dish types and pulls back a list of the names. So, in the Meat column, the list would show Steak, Chicken, Sausages ... while the Vegetable 1 column would show Carrots, Corn, Potatoes ... and so on. Vegetable 1 and Vegetable 2 would pull back the same list of vegetables, it's only to make sure I remember to eat enough vegetables!

I have defined a range for Table 1, which is FOODTYPE for the second column.

I can return the first value with an INDEX and MATCH, shown in the first row of Table 2, but I'm struggling to get the code written to get a full list and I am completely baffled.

I hope someone can help me with this. Eventually I'll be able to compile a shopping list based on the ingredients in each meal, but ... one step at a time

I really want to stick to a function as I think that will work on an iPhone/iPad when I'm in the super market and I think that VBA is disabled on iOS.

Thank you so much!

CL

Hi, thanks for getting back to me -

Do you mean that instead of having one column with values like "Meat" and "Vegetables", I have say 3 columns titled "Meat" etc, and then set the values to "Yes" or "No" for each listed food?

Thanks!