Menu information is in a seperate table called "Menu" on another sheet

In H14 enter a formula to look up the Cost for the Menu code in C14 and size in E14 from the Menu table. Formula should copy down. In 114 enter a formula to calculate the Total Cost for that Menu item. Include a check in the calculation to see if the menu item is Off Menu, if it is return a cost of 0. (Items with a cost of 0 will automatically highlighted in orange to alert the user that they have selected an item that is not available.) 170 x fx AB D E F G H lc Catering Job Costs 4 5 6 Client Parmis Technologies #N/A Job Number: 4155 7 Contact 8 9 Job Description Sales Conference 11/8/20 10 11 12 13 Size Cost/Unit Cost/Unit Total Cost 14 15 16 17 18 Description Lasagna Vegetarian Garlic Prawns and Pasta Roast Vegetables Chicken Cacciatore Herb Crusted Leg of Lamb Roast Chicken Roll Platter Vegetable Kebabs 19 20 21 Sushi 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 FOOD COSTS (MATERIALS) Menu Code Quantity 3341 2 2697 3 1873 2 2267 2 1780 1 1913 1 1660 1 3523 2 2965 2 1793 3 2557 3 3776 3 2841 3 2135 2 3693 1 3923 2 2518 1 2992 3 1181 2 3262 3 3436 2 3810 2 2874 1 1721 1 3361 2 2570 1 Large Large Large Large Medium Medium Large Large Large Medium Medium Large Medium Large Large Large Medium Large Medium Medium Large Large Medium Medium Large Large Mini Quiches Foccacia Platter - Vegetarian Crumbed Calamari Platter Fresh Seafood Platter Antipasto (Mixed Meat, Cheese and Olive Platter) Lemon Chicken Fingers Platter Vegetarian Platter Mini Spring Rolls Cheesy Tomato Basil Mussels Glazed Chicken Bites Cheese & Herb Potato Croquettes Bocconcini Tomato Skewers Garden Green Salad Greek Salad Italian Fruit Torte Tiramisu Lemon and Lime Tart Apple Pie Category Mains Mains Mains Mains Mains Mains Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Finger Foods Salads Salads Salads Desserts Desserts Desserts Desserts 41 42 43 44 45 $ 0.00 TOTAL FOOD COSTS July Job List Cost Overview Client Database Menu JOB_4155 Journals +