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

Product | Department | Supplier | Price | Quantity | Unit Price | Date | % change | Order Code | Notes |  | Departments
10" Greaseproof bag | TA Packaging | ABPAC | 16.82 | 1000 |  |  |  | 1234 | Test |  | TA Packaging |  |  | 12oz compostable d/w cup |  | BAKO
10" Greaseproof bag | TA Packaging | BAKO | 16 | 1000 |  |  |  |  |  |  | [NAME] |  |  | 12oz compostable lid |  | Bonds Packaging
10" Greaseproof bag | TA Packaging | Catering 24 | 19.02 | 1000 |  |  |  |  |  |  | [NAME] |  |  | 7" Greaseproof bag |  | BOOKER
12oz compostable d/w cup | TA Packaging | Catering 24 | 45.54 | 500 |  |  |  |  |  |  | Cleaning Supplies |  |  | 8oz compostable d/w  cup |  | Catering 24
12oz compostable d/w cup | TA Packaging | Next Day Coffee | 43.19 | 500 |  |  |  |  |  |  |  |  |  | 8oz compostable d/w cup |  | Cups Direct
12oz compostable d/w cup | TA Packaging | [NAME] | 53.1 | 500 |  |  |  |  |  |  |  |  |  | 8oz compostable lid |  | Enviropack
12oz compostable lid | TA Packaging | Catering 24 | 53.99 | 1000 |  |  |  |  |  |  |  |  |  | Alu Traywash MD6 |  | Enviropack 4+
12oz compostable lid | TA Packaging | Next Day Coffee | 29.75 | 500 |  |  |  |  |  |  |  |  |  | [NAME] |  | Enviropack 5+
12oz compostable lid | TA Packaging | [NAME] | 54.84 | 1000 |  |  |  |  |  |  |  |  |  | Apple & Lemon Tea |  | JMP
7" Greaseproof bag | TA Packaging | ABPAC | 10.28 | 1000 |  |  |  |  |  |  |  |  |  | Baileys |  | Mr Duffin
7" Greaseproof bag | TA Packaging | BAKO | 6.88 | 1000 |  |  |  |  |  |  |  |  |  | [NAME] |  | Next Day Coffee
7" Greaseproof bag | TA Packaging | Catering 24 | 9.77 | 1000 |  |  |  |  |  |  |  |  |  | Blue Centrefeed Roll |  | Penningtons
8oz compostable d/w cup | TA Packaging | Catering 24 | 38.34 | 500 |  |  |  |  |  |  |  |  |  | [NAME] |  | SUMA
8oz compostable d/w cup | TA Packaging | Next Day Coffee | 38.39 | 500 |  |  |  |  |  |  |  |  |  | Cawston Cloudy Apple & Elderflower |  | Supplier
8oz compostable d/w cup | TA Packaging | [NAME] | 43.56 | 500 |  |  |  |  |  |  |  |  |  | Cawston Cloudy Apple Juice |  | [NAME]
8oz compostable lid | TA Packaging | Catering 24 | 59.34 | 1000 |  |  |  |  |  |  |  |  |  | Cawston Cloudy Apple Juice & Rhubarb
8oz compostable lid | TA Packaging | Next Day Coffee | 25.19 | 500 |  |  |  |  |  |  |  |  |  | Cawston Press Apple & Elderflower
8oz compostable lid | TA Packaging | [NAME] | 45.35 | 1000 |  |  |  |  |  |  |  |  |  | Cawston Press Apple Juice
Nesting Tray | TA Packaging | ABPAC | 32.74 | 500 |  |  |  |  | Too Expensive |  |  |  |  | Chit Chat Coffee
Nesting Tray | TA Packaging | Bonds Packaging | 21.12 | 220 |  |  |  |  |  |  |  |  |  | Chit Chat Decaf Coffee
No. 1 [NAME] | TA Packaging | Catering 24 | 56.99 | 450 |  |  |  |  |  |  |  |  |  | Chit Chat Retail Coffee
No. 1 [NAME] | TA Packaging | Enviropack | 59.94 | 450 |  |  |  |  |  |  |  |  |  | Citrus Grove Airfreshner
No. 1 [NAME] | TA Packaging | Enviropack 4+ | 56.39 | 450 |  |  |  |  |  |  |  |  |  | Coke
No. 3 [NAME] | TA Packaging | Catering 24 | 42.24 | 180 |  |  |  |  |  |  |  |  |  | Coke BIB
No. 3 [NAME] | TA Packaging | Enviropack | 44.34 | 180 |  |  |  |  |  |  |  |  |  | Decaf Tea
No. 3 [NAME] | TA Packaging | Enviropack 4+ | 41.99 | 180 |  |  |  |  |  |  |  |  |  | Diet Coke
Perforated Film Front [NAME] bag | TA Packaging | Enviropack | 36.54 | 1000 |  |  |  |  |  |  |  |  |  | Diet Coke BIB
Perforated Film Front [NAME] bag | TA Packaging | Enviropack 5+ | 33.59 | 1000 |  |  |  |  |  |  |  |  |  | Dishwash Detergent 20l
Perforated Film Front [NAME] bag | TA Packaging | Next Day Coffee | 39.59 | 1000 |  |  |  |  |  |  |  |  |  | [NAME]
SOS Carrier Bag | TA Packaging | Catering 24 | 21.59 | 250 |  |  |  |  |  |  |  |  |  | Fine Lakeland Tea (1kg)
SOS Carrier Bag | TA Packaging | Enviropack | 21.59 | 250 |  |  |  |  |  |  |  |  |  | Ginger Beer
SOS Carrier Bag | TA Packaging | Enviropack 5+ | 19.79 | 250 |  |  |  |  |  |  |  |  |  | [NAME]
8oz compostable d/w  cup | TA Packaging | Cups Direct | 41.94 | 500 |  |  |  |  |  |  |  |  |  | [NAME] Detergent 5l
12oz compostable d/w cup | [NAME] | Cups Direct | 51.54 | 500 |  |  |  |  |  |  |  |  |  | [NAME] Aid 5l
Coke | [NAME] | BOOKER | 10.99 | 24 |  |  |  |  |  |  |  |  |  | Hand Towels Zig Zag
Diet Coke | [NAME] | BOOKER | 8.99 | 24 |  |  |  |  |  |  |  |  |  | [NAME]
Volvic | [NAME] | BOOKER | 3.89 | 24 |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | [NAME] | BOOKER | 9.99 | 24 |  |  |  |  |  |  |  |  |  | [NAME] 5l
San Pellegrino Orange | [NAME] | BOOKER | 9.99 | 24 |  |  |  |  |  |  |  |  |  | Jangro Glass & Mirror Cleaner
San Pellegrino Sparkling | [NAME] | BOOKER | 4.49 | 24 |  |  |  |  |  |  |  |  |  | Jangro Supreme Washing Up Liquid 5l
Kombucha Original | [NAME] | SUMA | 12.75 | 12 |  |  |  |  |  |  |  |  |  | Jangro Toilet Rolls
[NAME] | [NAME] | SUMA | 12.75 | 12 |  |  |  |  |  |  |  |  |  | K4 Kitchen Sanitiser
Cawston Cloudy Apple Juice | [NAME] | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  | K5 [NAME]
Cawston Cloudy Apple Juice & Rhubarb | [NAME] | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  | Kendal Mint Cake Tea
Cawston Cloudy Apple & Elderflower | [NAME] | SUMA | 16.97 | 24 |  |  |  |  |  |  |  |  |  | [NAME]
Penningtons Fine Lakeland Tea 250g | [NAME] | Penningtons | 5.35 | 250 |  |  |  |  |  |  |  |  |  | Kombucha Original
Chit Chat Coffee | [NAME] | Mr Duffin | 15.8 | 66 |  |  |  |  |  |  |  |  |  | Nesting Tray
Chit Chat Retail Coffee | [NAME] | Mr Duffin | 4.3 | 1 |  |  |  |  |  |  |  |  |  | No. 1 [NAME]
Chit Chat Decaf Coffee | [NAME] | Mr Duffin | 17.5 | 66 |  |  |  |  |  |  |  |  |  | No. 3 [NAME]
Pimms | [NAME] | Booker | 10.99 | 1 |  |  |  |  |  |  |  |  |  | Old Mout Berries & Cherries
Baileys | [NAME] | Booker | 10.99 | 1 |  |  |  |  |  |  |  |  |  | Old Mout Kiwi & Lime
Coke BIB | [NAME] | Booker | 61.99 | 1 |  |  |  | 5555 | 7777 |  |  |  |  | Orange Syrup
Diet Coke BIB | [NAME] | Booker | 51.99 | 1 |  |  |  |  |  |  |  |  |  | Passionfriut & Orange
Ginger Beer | [NAME] | Booker | 10.99 | 12 |  |  |  |  |  |  |  |  |  | Penningtons Fine Lakeland Tea 250g
Old Mout Berries & Cherries | [NAME] | Booker | 16.19 | 12 |  |  |  |  |  |  |  |  |  | Perforated Film Front [NAME] bag
Old Mout Kiwi & Lime | [NAME] | Booker | 16.19 | 12 |  |  |  |  |  |  |  |  |  | Perfumed Toilet Cleaner
Peroni | [NAME] | Booker | 20.99 | 24 |  |  |  |  |  |  |  |  |  | Peroni
Shipyard American IPA | [NAME] | Booker | 10.49 | 8 |  |  |  |  |  |  |  |  |  | Pimms
Wyldwood Organic Cider | [NAME] | Booker | 9.99 | 10 |  |  |  |  |  |  |  |  |  | Poppies [NAME] (Box)
Scweppes BIB | [NAME] | Booker | 58.99 | 1 |  |  |  |  |  |  |  |  |  | Product
Strathmore Still Mineral Water | [NAME] | Booker | 6.85 | 24 |  |  |  |  |  |  |  |  |  | Prosecco Spumante
Strathmore Sparkling Mineral Water | [NAME] | Booker | 6.39 | 24 |  |  |  |  |  |  |  |  |  | Rinse Aid 20l
Prosecco Spumante | [NAME] | Booker | 24.99 | 12 |  |  |  |  |  |  |  |  |  | [NAME]
Cawston Press Apple Juice | [NAME] | Suma | 11.7 | 6 |  |  |  |  |  |  |  |  |  | San Pellegrino Orange
Cawston Press Apple & Elderflower | [NAME] | Suma | 11.7 | 6 |  |  |  |  |  |  |  |  |  | San Pellegrino Sparkling
[NAME] | [NAME] | Booker | 18.99 | 1040 |  |  |  |  |  |  |  |  |  | Scweppes BIB
[NAME] | [NAME] | JMP | 21.88 | 1040 |  |  |  |  |  |  |  |  |  | Shipyard American IPA
Orange Syrup | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | SOS Carrier Bag
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | Strathmore Sparkling Mineral Water
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | Strathmore Still Mineral Water
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | Sugar Sticks Brown
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | Sugar Sticks White
[NAME] | [NAME] | Next Day Coffee | 6.69 | 1 |  |  |  |  |  |  |  |  |  | Twinings Green Tea
Fine Lakeland Tea (1kg) | [NAME] | Penningtons | 18.5 | 1000 |  |  |  |  |  |  |  |  |  | Twinings Lemon & Ginger Tea
Decaf Tea | [NAME] | Penningtons | 3.45 | 40 |  |  |  |  |  |  |  |  |  | Twinings Peppermint Tea
[NAME] | [NAME] | Penningtons | 4.15 |  |  |  |  |  |  |  |  |  |  | [NAME]
Kendal Mint Cake Tea | [NAME] | Penningtons | 4.15 |  |  |  |  |  |  |  |  |  |  | Volvic
Apple & Lemon Tea | [NAME] | Penningtons | 4.15 |  |  |  |  |  |  |  |  |  |  | W1 Washroom Cleaner
Passionfriut & Orange | [NAME] | Penningtons | 4.15 |  |  |  |  |  |  |  |  |  |  | Wyldwood Organic Cider
[NAME] | [NAME] | Penningtons | 3.75 | 40 |  |  |  |  |  |  |  |  |  | [NAME]
Sugar Sticks White | [NAME] | Penningtons | 10.6 | 1000
Sugar Sticks Brown | [NAME] | Penningtons | 11.45 | 1000
[NAME] | [NAME] | Penningtons | 8.7 | 1
Twinings Peppermint Tea | [NAME] | JMP | 2.02 | 20
Twinings Lemon & Ginger Tea | [NAME] | JMP | 2.02 | 20
Twinings Green Tea | [NAME] | JMP | 2.02 | 20
[NAME] | [NAME] | Next Day Coffee | 27.99 | 1040
Blue Centrefeed Roll | Cleaning Supplies | [NAME] | 10.13 | 6
Dishwash Detergent 20l | Cleaning Supplies | [NAME] |  | 1
Rinse Aid 20l | Cleaning Supplies | [NAME] |  | 1
Alu Traywash MD6 | Cleaning Supplies | [NAME] | 28.73 | 1
[NAME] Detergent 5l | Cleaning Supplies | [NAME] | 3.53 | 1
[NAME] Aid 5l | Cleaning Supplies | [NAME] |  | 1
Jangro Supreme Washing Up Liquid 5l | Cleaning Supplies | [NAME] |  | 1
K5 [NAME] | Cleaning Supplies | [NAME] | 7.21 | 1
K4 Kitchen Sanitiser | Cleaning Supplies | [NAME] |  | 1
W1 Washroom Cleaner | Cleaning Supplies | [NAME] |  | 1
Perfumed Toilet Cleaner | Cleaning Supplies | [NAME] |  | 1
[NAME] 5l | Cleaning Supplies | [NAME] | 5.41 | 1
Jangro Glass & Mirror Cleaner | Cleaning Supplies | [NAME] |  | 1
[NAME] | Cleaning Supplies | [NAME] |  | 1
Citrus Grove Airfreshner | Cleaning Supplies | [NAME] |  | 1
Poppies [NAME] (Box) | Cleaning Supplies | [NAME] | 26.93 | 2000
Jangro Toilet Rolls | Cleaning Supplies | [NAME] | 23.46 | 36
Hand Towels Zig Zag | Cleaning Supplies | [NAME] | 21.8 | 20