Spreadsheet: 760985d1640589588-match-title-then-vlookup-from-table-below-excel-help-forum-offset-address
Sheet: Recipes

American Moby |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Spicy Thai Burger
Cost of Sale |  | 21.57762698588224 |  |  | Net COST Margin |  | 0.269720337323528 |  |  |  |  | Cost of Sale |  | 20.18631060042355 |  |  | Net COST Margin |  | 0.2523288825052943 |  |  |  |  | Cost of Sale |  | 20.29295904504125 |  |  | Net COST Margin |  | 0.2536619880630157
Net Sales Price |  | 80 |  |  | Net Profit Margin |  | 0.730279662676472 |  |  |  |  | Net Sales Price |  | 80 |  |  | Net Profit Margin |  | 0.7476711174947057 |  |  |  |  | Net Sales Price |  | 80 |  |  | Net Profit Margin |  | 0.7463380119369843
Gross Sales Price |  | 100 |  |  | Profit Per Sale |  | 58.42237301411777 |  |  |  |  | Gross Sales Price |  | 100 |  |  | Profit Per Sale |  | 59.81368939957645 |  |  |  |  | Gross Sales Price |  | 100 |  |  | Profit Per Sale |  | 59.70704095495875
INGREDIENTS |  |  |  |  |  |  |  |  |  |  |  | INGREDIENTS |  |  |  |  |  |  |  |  |  |  |  | INGREDIENTS
Item |  |  |  |  | Qu | UOM | COS |  |  |  |  | Item |  |  |  |  | Qu | UOM | COS |  |  |  |  | Item |  |  |  |  | Qu | UOM | COS
Beef patty 170G |  |  |  |  | 0.17 | Kg | 9.146 |  |  |  |  | Beef patty 170G |  |  |  |  | 0.17 | Kg | 9.146 |  |  |  |  | Beef patty 170G |  |  |  |  | 0.17 | Kg | 9.146
Burger Bun 80G |  |  |  |  | 1 | EA | 6.25 |  |  |  |  | Burger Bun 80G |  |  |  |  | 1 | EA | 6.25 |  |  |  |  | Burger Bun 80G |  |  |  |  | 1 | EA | 6.25
Cheese ([NAME]) |  |  |  |  | 0.02 | Kg | 1.329 |  |  |  |  | Cheese ([NAME]) |  |  |  |  | 0.02 | Kg | 1.329 |  |  |  |  | Chili Fresh (Red) |  |  |  |  | 0.005 | Kg | 0.32035
Tomatoes |  |  |  |  | 0.025 | Kg | 0.39625 |  |  |  |  | Tomatoes |  |  |  |  | 0.025 | Kg | 0.39625 |  |  |  |  | Tomatoes |  |  |  |  | 0.025 | Kg | 0.39625
[NAME] |  |  |  |  | 0.01 | Kg | 1.5007 |  |  |  |  | CK Classic Mayonnaise |  |  |  |  | 0.02 | Kg | 0.3104727613412229 |  |  |  |  | Coriander |  |  |  |  | 0.005 | Kg | 1.02355
Romaine Lettuce |  |  |  |  | 0.025 | Kg | 0.76875 |  |  |  |  | Romaine Lettuce |  |  |  |  | 0.025 | Kg | 0.76875 |  |  |  |  | Romaine Lettuce |  |  |  |  | 0.025 | Kg | 0.76875
Marinated Onion |  |  |  |  | 0.01 | Kg | 0.1472204790823212 |  |  |  |  | Marinated Onion |  |  |  |  | 0.01 | Kg | 0.1472204790823212 |  |  |  |  | Marinated Onion |  |  |  |  | 0.01 | Kg | 0.1472204790823212
[NAME] (Large) |  |  |  |  | 1 | Ea | 0.6 |  |  |  |  | [NAME] (Large) |  |  |  |  | 1 | Ea | 0.6 |  |  |  |  | [NAME] (Large) |  |  |  |  | 1 | Ea | 0.6
Bacon |  |  |  |  | 0.01 | Kg | 0.598 |  |  |  |  | Bacon |  |  |  |  | 0.01 | Kg | 0.598 |  |  |  |  | Bacon |  |  |  |  | 0.01 | Kg | 0.598
CK Choron Mayo |  |  |  |  | 0.04 | Kg | 0.8417065067999169 |  |  |  |  | CK Chili Sauce |  |  |  |  | 0.02 | Kg | 0.64061736 |  |  |  |  | CK Thai Mayo |  |  |  |  | 0.04 | Kg | 1.042838565958928
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CK Choron Mayo |  |  |  |  | 0.04 | Kg | 0.8417065067999169
[NAME] |  |  |  |  |  |  |  |  |  |  |  | Thai Green Curry Soup |  |  |  |  |  |  |  |  |  |  |  | Gazpacho
Cost of Sale |  | 16.71306558441558 |  |  | Net COST Margin |  | 0.4178266396103896 |  |  |  |  | Cost of Sale |  | 17.6172657321393 |  |  | Net COST Margin |  | 0.3670263694195688 |  |  |  |  | Cost of Sale |  | 17.17889922480621 |  |  | Net COST Margin |  | 0.268420300387597
Net Sales Price |  | 40 |  |  | Net Profit Margin |  | 0.5821733603896104 |  |  |  |  | Net Sales Price |  | 48 |  |  | Net Profit Margin |  | 0.6329736305804312 |  |  |  |  | Net Sales Price |  | 64 |  |  | Net Profit Margin |  | 0.7315796996124031
Gross Sales Price |  | 50 |  |  | Profit Per Sale |  | 23.28693441558442 |  |  |  |  | Gross Sales Price |  | 60 |  |  | Profit Per Sale |  | 30.3827342678607 |  |  |  |  | Gross Sales Price |  | 80 |  |  | Profit Per Sale |  | 46.8211007751938
INGREDIENTS |  |  |  |  |  |  |  |  |  |  |  | INGREDIENTS |  |  |  |  |  |  |  |  |  |  |  | INGREDIENTS
Item |  |  |  |  | Qu | UOM | COS |  |  |  |  | Item |  |  |  |  | Qu | UOM | COS |  |  |  |  | Item |  |  |  |  | Qu | UOM | COS
CK Tomato Soup |  |  |  |  | 0.4 | Kg | 10.18301558441559 |  |  |  |  | CK [NAME] |  |  |  |  | 0.4 | Kg | 9.477485572139303 |  |  |  |  | CK Gullasch Soup |  |  |  |  | 0.4 | Kg | 10.8572992248062
Pasta (Suppehorn) |  |  |  |  | 0.04 | Kg | 0.4464 |  |  |  |  | CK Poached [NAME] |  |  |  |  | 0.04 | Kg | 1.96830016 |  |  |  |  | Parsley Fresh |  |  |  |  | 0.01 | Kg | 0.5332
Croutons (Prep) |  |  |  |  | 0.015 | Kg | 0.29525 |  |  |  |  | Apples ([NAME]) |  |  |  |  | 0.008 | Kg | 0.11008 |  |  |  |  | Sour Cream Dip |  |  |  |  | 1 | EA | 1.0584
Sour Cream Dip |  |  |  |  | 1 | EA | 1.0584 |  |  |  |  | Chili Fresh (Red) |  |  |  |  | 0.008 | Kg | 0.5125599999999999 |  |  |  |  | Cup 360Ml |  |  |  |  | 1 | Ea | 2.99
Cup 360Ml |  |  |  |  | 1 | Ea | 2.99 |  |  |  |  | Coriander |  |  |  |  | 0.004 | Kg | 0.81884 |  |  |  |  | Cup 360Ml Lid |  |  |  |  | 1 | Ea | 1.74
Cup 360Ml Lid |  |  |  |  | 1 | Ea | 1.74 |  |  |  |  | Cup 360Ml |  |  |  |  | 1 | Ea | 2.99
 |  |  |  |  |  |  |  |  |  |  |  | Cup 360Ml Lid |  |  |  |  | 1 | Ea | 1.74