Good-day
I am working on a menu list which is on sheet 1 (Meals price List) columns A5 to A8.
I also have sheet 2 (Item price List) which is the list of ingredients that go into a recipe. Then I have Sheets 3, 4, 5 and 6. (The different recipes (Worksheet names) as indicated below:-
1. Beef curry
2. Broad beans Curry
3. Cabbage Curry
4. Corned meat Curry
I am trying to use the drop down function in sheet 1(Meals Price List) for Columns A5 to A38, these need to be the heading of each recipe e.g. Beef Curry, in other words I want to choose which Recipe (Sheets 3,4,5 and 6) I want from the list.
Then I need to do a lookup of each recipe on the dropdown to tie into each meal total found on each recipe (B34) this should be displayed under price per meal heading Sheet in sheet 1(Meals Price List) columns B5 to B8 for each meal or recipe.
Bookmarks