Hi,
I am pretty rusty at Excel, but I have been trying to create a menu application (real breakfast, lunch, dinner menus). The basic idea is to let the dietitians enter the date, meal period (breakfast, lunch, dinner) and the meal item on the first sheet in the workbook. There's an intermediate worksheet (invisible to the user) with calcs & whatnot. Then on the last sheet I format a pretty, printable calendar grid, with Monday through Friday across the top and menu items down.
The lookups and validations & other stuff...that's all working...the problem is in filling in the weekday grid.
I calculate a grid location for each item on the second worksheet, and here's the first two colums of that sheet:
Menu_loc Menu Item
D1 Chicken-Breaded
D1 Potato Rounds
E1 Macaroni & Cheese
E1 Cucumber Coins
E1 Meatloaf
F1 Grapes, Fresh Red
F1 Pizza, Sausage
When I go looking for data for the "E1" location using VLOOKUP, I only get one item...not all three. My grid would work beautifully but you can only get one thing for breakfast.
It seems like I should change the menu_loc I have calculated. I think that I want to end up with a menu_loc like "E11" being "Macaroni & Cheese", "E12" being "Cucumber Coins" and so forth. Then I could add additional lines to my weekday grid and use VLOOKUP to return the specific row.
If I do that, how do I add what's essentially a sequence number to my grid location? Or can I keep what I have and use some clever VLOOKUP trick to return multiple rows?
Thanks!
I am pretty rusty at Excel, but I have been trying to create a menu application (real breakfast, lunch, dinner menus). The basic idea is to let the dietitians enter the date, meal period (breakfast, lunch, dinner) and the meal item on the first sheet in the workbook. There's an intermediate worksheet (invisible to the user) with calcs & whatnot. Then on the last sheet I format a pretty, printable calendar grid, with Monday through Friday across the top and menu items down.
The lookups and validations & other stuff...that's all working...the problem is in filling in the weekday grid.
I calculate a grid location for each item on the second worksheet, and here's the first two colums of that sheet:
Menu_loc Menu Item
D1 Chicken-Breaded
D1 Potato Rounds
E1 Macaroni & Cheese
E1 Cucumber Coins
E1 Meatloaf
F1 Grapes, Fresh Red
F1 Pizza, Sausage
When I go looking for data for the "E1" location using VLOOKUP, I only get one item...not all three. My grid would work beautifully but you can only get one thing for breakfast.
It seems like I should change the menu_loc I have calculated. I think that I want to end up with a menu_loc like "E11" being "Macaroni & Cheese", "E12" being "Cucumber Coins" and so forth. Then I could add additional lines to my weekday grid and use VLOOKUP to return the specific row.
If I do that, how do I add what's essentially a sequence number to my grid location? Or can I keep what I have and use some clever VLOOKUP trick to return multiple rows?
Thanks!