task_description: Created Grocery Shopping Comparison Spread Sheet. Two pages were made for this. Page 1 "Grocery Data" contained a database which included basic information about each potential item, and the cost of each unit across 4 major retailers. The price of each item across each retailer is compared and then the sections for Best Value, 2nd Best, and 3rd Best are filled out based on the cheapest and sequentially best options. Based of the information for items put into this database, an individual can then use Page 2 "Grocery list" to create a shopping list where they simply put in the item they are after and the quantity of said item. Using various formulas, the category, unit, best store, best unit cost, total, savings are all calculated from the data in "Grocery Data".  The Grocery List subtotal is also calculated and the total savings made when compared to the worst possible option of retailer for the specific items
synthetically_generated_instruction: Create a Grocery Shopping Comparison Spreadsheet in Google Sheets with two sheets: "Grocery Data" and "Grocery List".\n\n1. **Grocery Data Sheet:**\n   - Create columns for "Item Name", "Category", "Unit", and the names of four major retailers (e.g., Freshmart, Grubhub, Coles, Woolworths).\n   - Add columns for "Best Store", "Best Unit Cost", "2nd Best", "3rd Best", and "Savings".\n   - Populate the "Item Name" column with items such as Bread, Milk, Vitamin C, Ketchup, Detergent, Chicken, Tissue, Ice Cream, Muffins, Pepper, Juice, Cheese, Protein Bar, Soy Sauce, Air Freshener, Beef, Napkins, Frozen Pizza, Bagels, Garlic Powder, Lemonade, and Yogurt.\n   - Enter unit prices for each item across the retailers.\n   - Use formulas to determine the "Best Store" and "Best Unit Cost" by finding the minimum price across the retailers for each item.\n   - Calculate "2nd Best" and "3rd Best" using the `LARGE` function to find the second and third lowest prices.\n   - Calculate "Savings" by comparing the best price to the worst price and multiplying by the quantity.\n\n2. **Grocery List Sheet:**\n   - Create columns for "No.", "Item", "Quantity", "Category", "Unit", "Best Store", "Best Unit Cost", "Total", and "Savings".\n   - Use data validation or a dropdown list for the "Item" column to select items from the "Grocery Data" sheet.\n   - Use VLOOKUP or INDEX-MATCH formulas to automatically fill in "Category", "Unit", "Best Store", and "Best Unit Cost" based on the selected item.\n   - Calculate "Total" by multiplying "Best Unit Cost" by "Quantity".\n   - Calculate "Savings" by comparing the total cost using the best price to the total cost using the worst price.\n   - Add a formula to calculate the "Grocery List Total" and "Total Savings" at the bottom of the list.\n\nEnsure all formulas are correctly linked between the two sheets to dynamically update as data is entered or changed.