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
Bookmarks