Spreadsheet: 856405d1705658270-2-spreadsheets-different-rows-duplicate-data-lookup-help-needed-trying-to-work-out-rayteds-requirements-aligw
Sheet: EH2_FILE2

 |  |  |  |  |  | 848
 | Prod | Description | BC | BC Description |  | BCatgry
 | 30 | MCGGN ES AUS RS OTH11.5%18.75C | '[PHONE] | Mcguigan Estate Rose Wine 11.5% 187ml [NAME] Bottle Australia |  | Still [NAME]
 | 32 | CSLR D DBL DC O.S WT CHL12%75C | '[PHONE] | Casillero Del Diablo Devils Collection Brut Chardonnay 12% 75cl [NAME] Chile |  | Total Other Sparkling Wine
 | 35 | KLEIN ST SA RD MERLOT 13% 75CL | '[PHONE] | [NAME] 13% Red Wine 75cl  [NAME] |  | Still Red Wine
 | 178 | KRNBG 1664 P.LG CN 5%  4X440ML |  |  |  | Premium Lager
 | 216 | RED STRP P.LGR CN 4.7%   440ML |  |  |  | World Beer
 | 302 | C.D.O SPN RD OT      13.5%75CL | '[PHONE] | Castillo De Olite Tinto Navarra Red Wine 13.5% Spain Glass Bottle 75cl |  | Still Red Wine
 | 357 | GLMRGN WLSH CK STT BT4.5%500ML | '[PHONE] | [NAME] 4.5% 500ml Glass Bottle |  | Stouts & Porters
 | 358 | B.D HOP RCKR P.LG CN 5.2%660ML | '[PHONE] | [NAME] India Pale Lager 5.2% Glass Bottle 660ml |  | Craft Beer
 | 360 | PERRYS VINTAGE BTL 7.2%  500ML | '[PHONE] | Perrys Somerset Cider Vintage 7.2% Glass Bottle 500ml |  | Apple Cider
 | 364 | BIRRA MRTI G/AN P.LG BT8%750ML | '[PHONE] | [NAME] Antichi 8% Premium Lager Glass Bottle 750ml |  | World Beer
 | 476 | TRS CLST SPNSH OTHR RD 14%75CL | '[PHONE] | Torres Celeste Crianza Red Wine Spain 14% Glass Bottle 75cl |  | Still Red Wine
 | 496 | WSTNS OLD RSE SCRMP 6.8%BT500M | '[PHONE] | Westons Old Rosie The Original Cloudy Cider 6.8% Glass Bottle 500ml |  | Apple Cider
 | 499 | SNS SPNSH RED RIOJA  13.5%75CL | '00335331 | Canto Sainsburys By [NAME] Tempranillo Garnacha Spain Red Wine Glass Bottle 13.5% 75cl |  | Still Red Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc White Wine 13% 75cl [NAME] Bottle Australia |  | Still White Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc Australia 13% 75cl White Wine Glass Bottle |  | Still White Wine
 | 533 | HEINEKEN/S S.LGR BT 4% 4X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 4% 4x330ml [NAME] |  | Premium Lager
 | 546 | BAILEYS ETON MESS 17%     70CL | '[PHONE] | [NAME] Liqueur 17% 70cl Glass Bottle |  | Cream Liqueurs
 | 597 | SAINT ETIENNE P.LG C4.6% 440ML |  |  |  | Value Beer
 | 598 | [NAME] C4.6%4X440M |  |  |  | Value Beer
 | 631 | HEINEKEN/S S.LGR CN 4% 6X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 6x330ml Cans |  | Premium Lager
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry 4% Spirit Based Drink 70cl Glass Bottle |  | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry Spirit Based Drink 4% 70cl Glass Bottle Pmp £2.79 |  | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry W Alcohol & Fruit Juice [Sparkling W Sug & Sweetenr] Glbt 70cl 4% Uk Pm 2.99 |  | Traditional RTD
 | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro Alcohol Free Lager 0.0% 12x330ml Glass Bottles |  | Low & No Alc Beer
 | 795 | PERONI LGR 0.0% BTL   12X330ML | '[PHONE] | Peroni Nastro Azzurro 0.0% Non Alcoholic Italian Lager 12 X 330ml Glass Bottle |  | Low & No Alc Beer
 | Prod | Description | BC | BC Description | Prod in File Attachment 2 | Same as Prod in File Attachment 2 | File Attachment 2 has Bcatgry values: | BCatgry
 | 30 | MCGGN ES AUS RS OTH11.5%18.75C | '[PHONE] | Mcguigan Estate Rose Wine 11.5% 187ml [NAME] Bottle Australia | 30 | Yes |  | Still [NAME]
 | 32 | CSLR D DBL DC O.S WT CHL12%75C | '[PHONE] | Casillero Del Diablo Devils Collection Brut Chardonnay 12% 75cl [NAME] Chile | 32 | Yes |  | Total Other Sparkling Wine
 | 35 | KLEIN ST SA RD MERLOT 13% 75CL | '[PHONE] | [NAME] 13% Red Wine 75cl  [NAME] | 35 | Yes |  | Still Red Wine
 | 178 | KRNBG 1664 P.LG CN 5%  4X440ML |  |  | 178 | Yes |  | Premium Lager
 | 216 | RED STRP P.LGR CN 4.7%   440ML |  |  | 216 | Yes |  | World Beer
 | 302 | C.D.O SPN RD OT      13.5%75CL | '[PHONE] | Castillo De Olite Tinto Navarra Red Wine 13.5% Spain Glass Bottle 75cl | 302 | Yes |  | Still Red Wine
 | 357 | GLMRGN WLSH CK STT BT4.5%500ML | '[PHONE] | [NAME] 4.5% 500ml Glass Bottle | 357 | Yes |  | Stouts & Porters
 | 358 | B.D HOP RCKR P.LG CN 5.2%660ML | '[PHONE] | [NAME] India Pale Lager 5.2% Glass Bottle 660ml | 358 | Yes |  | Craft Beer
 | 360 | PERRYS VINTAGE BTL 7.2%  500ML | '[PHONE] | Perrys Somerset Cider Vintage 7.2% Glass Bottle 500ml | 360 | Yes |  | Apple Cider
 | 364 | BIRRA MRTI G/AN P.LG BT8%750ML | '[PHONE] | [NAME] Antichi 8% Premium Lager Glass Bottle 750ml | 364 | Yes |  | World Beer
 | 476 | TRS CLST SPNSH OTHR RD 14%75CL | '[PHONE] | Torres Celeste Crianza Red Wine Spain 14% Glass Bottle 75cl | 476 | Yes |  | Still Red Wine
 | 496 | WSTNS OLD RSE SCRMP 6.8%BT500M | '[PHONE] | Westons Old Rosie The Original Cloudy Cider 6.8% Glass Bottle 500ml | 496 | Yes |  | Apple Cider
 | 499 | SNS SPNSH RED RIOJA  13.5%75CL | '00335331 | Canto Sainsburys By [NAME] Tempranillo Garnacha Spain Red Wine Glass Bottle 13.5% 75cl | 499 | Yes |  | Still Red Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc White Wine 13% 75cl [NAME] Bottle Australia | 513 | Yes |  | Still White Wine
 | 513 | HRDYS BIN AUST WH SVN BL13%75C | '[PHONE] | Hardys Bin 161 Sauvignon Blanc Australia 13% 75cl White Wine Glass Bottle | 513 | Yes |  | Still White Wine
 | 533 | HEINEKEN/S S.LGR BT 4% 4X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 4% 4x330ml [NAME] | 533 | Yes |  | Premium Lager
 | 546 | BAILEYS ETON MESS 17%     70CL | '[PHONE] | [NAME] Liqueur 17% 70cl Glass Bottle | 546 | Yes |  | Cream Liqueurs
 | 597 | SAINT ETIENNE P.LG C4.6% 440ML |  |  | 597 | Yes |  | Value Beer
 | 598 | [NAME] C4.6%4X440M |  |  | 598 | Yes |  | Value Beer
 | 631 | HEINEKEN/S S.LGR CN 4% 6X330ML | '[PHONE] | Heineken Silver Pure Malt Lager 6x330ml Cans | 631 | Yes |  | Premium Lager
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry 4% Spirit Based Drink 70cl Glass Bottle | 779 | Yes |  | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry Spirit Based Drink 4% 70cl Glass Bottle Pmp £2.79 | 779 | Yes |  | Traditional RTD
 | 779 | VK BLACK CHERRY BTL 4%   700ML | '[PHONE] | Vk Black Cherry W Alcohol & Fruit Juice [Sparkling W Sug & Sweetenr] Glbt 70cl 4% Uk Pm 2.99 | 779 | Yes |  | Traditional RTD
 | 887 | CSTLDMNR OR SP RD TMPR13.5%75C | '[PHONE] | Castillo De Menara Organic Tempranillo Gran Seleccion 13.5% Red Wine 75cl [NAME] Bottle Spain | 795 | No | Low & No Alc Beer | Still Red Wine
 | 922 | SPR BCK BT 4.7%          660ML | '[PHONE] | Super Bock Beer, 4.7%, [NAME], 660ml | 795 | No | Low & No Alc Beer | Premium Ale
 | 16723