Spreadsheet: 752604d1634846713-help-to-create-an-order-list-based-on-products-by-cheapest-supplier-price-comparison-with-autocomplete-data-validation-drop-down-paulanderson-
Sheet: Template

Product | Supplier | Price | Quantity | Unit Price | Date | % change | Notes |  | PRODUCT | SUPPLIER | PRICE |  | CHEAPEST PRICE | FROM
Chit Chat Coffee | Mr Duffin | 15.8 | 66 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Apple & Lemon Tea |  |  |  |  | JMP
Chit Chat Retail Coffee | Mr Duffin | 4.3 | 1 |  |  |  |  |  |  | JMP |  |  |  |  |  |  |  |  | Baileys |  |  |  |  | Mr Duffin
Chit Chat Decaf Coffee | Mr Duffin | 17.5 | 66 |  |  |  |  |  |  | Mr Duffin |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Next Day Coffee
Pimms | Booker | 10.99 | 1 |  |  |  |  |  |  | Next Day Coffee |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | Penningtons
Baileys | Booker | 10.99 | 1 |  |  |  |  |  |  | Penningtons |  |  |  |  |  |  |  |  | Cawston Press Apple & Elderflower |  |  |  |  | Suma
Coke BIB | Booker | 61.99 | 1 |  |  |  |  |  |  | Suma |  |  |  |  |  |  |  |  | Cawston Press Apple Juice
Diet Coke BIB | Booker | 51.99 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chit Chat Coffee
Ginger Beer | Booker | 10.99 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chit Chat Decaf Coffee
Old Mout Berries & Cherries | Booker | 16.19 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chit Chat Retail Coffee
Old Mout Kiwi & Lime | Booker | 16.19 | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Coke BIB
Peroni | Booker | 20.99 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Decaf Tea
Shipyard American IPA | Booker | 10.49 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Diet Coke BIB
Wyldwood Organic Cider | Booker | 9.99 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fine Lakeland Tea (1kg)
Scweppes BIB | Booker | 58.99 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ginger Beer
Strathmore Still Mineral Water | Booker | 6.85 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Strathmore Sparkling Mineral Water | Booker | 6.39 | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Prosecco Spumante | Booker | 24.99 | 12 |  |  |  |  |  | PRODUCT | SUPPLIER | PRICE | DATE CHECK | Difference | NOTES |  |  |  |  | Kendal Mint Cake Tea
Cawston Press Apple Juice | Suma | 11.7 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Old Mout Berries & Cherries
Cawston Press Apple & Elderflower | Suma | 11.7 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Old Mout Kiwi & Lime
[NAME] | Booker | 18.99 | 1040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Orange Syrup
[NAME] | JMP | 21.88 | 1040 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Peroni
Orange Syrup | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pimms
[NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prosecco Spumante
[NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scweppes BIB
[NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipyard American IPA
[NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Strathmore Sparkling Mineral Water
[NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Strathmore Still Mineral Water
Fine Lakeland Tea (1kg) | Penningtons | 18.5 | 1000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Decaf Tea | Penningtons | 3.45 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wyldwood Organic Cider
[NAME] | Penningtons | 4.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Kendal Mint Cake Tea | Penningtons | 4.15
Apple & Lemon Tea | Penningtons | 4.15
Passionfriut & Orange | Penningtons | 4.15
[NAME] | Penningtons | 3.75 | 40
Sugar Sticks White | Penningtons | 10.6 | 1000
Sugar Sticks Brown | Penningtons | 11.45 | 1000
[NAME] | Penningtons | 8.7 | 1
Twinings Peppermint Tea | JMP | 2.02 | 20
Twinings Lemon & Ginger Tea | JMP | 2.02 | 20
Twinings Green Tea | JMP | 2.02 | 20
[NAME] | Next Day Coffee | 27.99 | 1040