Spreadsheet: 854322d1704246301-vlookup-set-of-data-not-returning-full-result-run-rate-example-snook-adj-
Sheet: Skus

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
ASW# | Supplier Performance Group | Brand | Label | Vintage |  | Product Name | ASW Product | Pk | Size |  | 44463
44361196 | CDB | CDB | CDB 43 ED CUV EXT BRT | 0000 | [PHONE] | CDB 43 ED CUV EXT BRT 1PK 3L | CDB 43ED CUV ET BRT1P | 1 | 3L | 1
44361164 | CDB | CDB | CDB 43 ED CUV EXT BRT | 0000 | [PHONE] | CDB 43 ED CUV EXT BRT 1PK 6L | CDB 43 ED CUV EXT BRT | 1 | 6L | 1
44361300 | CDB | CDB | CDB 43 ED CUV EXT BRT | 0000 | [PHONE] | CDB 43 ED CUV EXT BRT 3PK 1.5L | CDB 43ED CUV ET BRT3P | 3 | 1.5L | 2
44361396 | CDB | CDB | CDB 43 ED CUV EXT BRT | 0000 | [PHONE] | CDB 43 ED CUV EXT BRT 6PK 750M | CDB 43ED CUV ET BRT6P | 6 | 750ml | 4
44361397 | CDB | CDB | CDB 44 ED CUV EXT BRT | 0000 | [PHONE] | CDB 44 ED CUV EXT BRT 6PK 750M | CDB 44ED CUV ET BRT6P | 6 | 750ml | 4
44361398 | CDB | CDB | CDB 45 ED CUV EXT BRT | 0000 | [PHONE] | CDB 45 ED CUV EXT BRT 6PK 750M | CDB 45ED CUV ET BRT6P | 6 | 750ml | 4
44361399 | CDB | CDB | CDB 46 ED CUV EXT BRT | 0000 | [PHONE] | CDB 46 ED CUV EXT BRT 6PK 750M | CDB 46ED CUV ET BRT6P | 6 | 750ml | 4
44338397 | CDB | CDB | CDB AMC ROSE | 2009 | [PHONE] | CDB AMC ROSE 1PK 750M 2009 | CDB AMC ROSE 1P | 1 | 750ml | 4
44338400 | CDB | CDB | CDB AMC ROSE | 2011 | [PHONE] | CDB AMC ROSE 3PK 750M 2011 | CDB AMC ROSE 3P | 3 | 750ml | 4
44338401 | CDB | CDB | CDB AMC ROSE | 2013 | [PHONE] | CDB AMC ROSE 3PK 750M 2013 | CDB AMC ROSE 3P | 3 | 750ml | 4
44338399 | CDB | CDB | CDB AMC ROSE | 2009 | [PHONE] | CDB AMC ROSE 3PK OL 750M 2009 | CDB AMC ROSE 3P | 3 | 750ml | 4
44337397 | CDB | CDB | CDB AMC | 2008 | [PHONE] | CDB AMC 6PK 750M 2008 | CDB AMC SPRK 6P | 6 | 750ml | 4
44337398 | CDB | CDB | CDB AMC | 2009 | [PHONE] | CDB AMC 6PK 750M 2009 | CDB AMC SPRK 6P | 6 | 750ml | 4
44337399 | CDB | CDB | CDB AMC | 2011 | [PHONE] | CDB AMC 6PK 750M 2011 | CDB AMC SPRK 6P | 6 | 750ml | 4
44337400 | CDB | CDB | CDB AMC | 2013 | [PHONE] | CDB AMC 6PK 750M 2013 | CDB AMC SPRK 6P | 6 | 750ml | 4
44337401 | CDB | CDB | CDB AMC | 2014 | [PHONE] | CDB AMC 6PK 750M 2014 | CDB AMC SPRK 6P | 6 | 750ml | 4
44345300 | CDB | CDB | CDB BRUT | 0000 | [PHONE] | CDB BRUT 3PK 1.5L | CDB BRUT PRESTIGE 3PK | 3 | 1.5L | 2
44363404 | CDB | CDB | CDB  CHARD | 2014 | [PHONE] | CDB  CHARD 6PK 750M 2014 | CDB CHARD 6PK | 6 | 750ml | 4
44363405 | CDB | CDB | CDB  CHARD | 2016 | [PHONE] | CDB  CHARD 6PK 750M 2016 | CDB CHARD 6PK | 6 | 750ml | 4
44363407 | CDB | CDB | CDB  CHARD | 2017 | [PHONE] | CDB  CHARD 6PK 750M 2017 | CDB CHARD 6PK | 6 | 750ml | 4
44363406 | CDB | CDB | CDB  CHARD | 2018 | [PHONE] | CDB  CHARD 6PK 750M 2018 | CDB CHARD 6PK | 6 | 750ml | 4
44362396 | CDB | CDB | CDB CUV PRES EXT BRUT | 0000 | [PHONE] | CDB CUV PRES EXT BRUT 6PK 750M | CDB CUVEE PRES EXBRUT | 6 | 750ml | 4
44345556 | CDB | CDB | CDB CUV BRUT | 0000 | [PHONE] | CDB CUV BRUT 12PK 375M | CDB BRUT PRESTIGE | 12 | 375ml | 6
44345557 | CDB | CDB | CDB CUV BRUT | 0000 | [PHONE] | CDB CUV BRUT 12PK W/SPECIAL FOIL | CDB BRUT PRES SPEC FL | 12 | 375ml | 6
44366396 | CDB | CDB | CDB CUV BRUT | 0000 | [PHONE] | CDB CUV BRUT 6PK 750M | CDB BRUT PRESTIGE 6P | 6 | 750ml | 4
44377396 | CDB | CDB | CDB CUV ROSE | 0000 | [PHONE] | CDB CUV ROSE 6PK 750M | CDB PRESTIGE ROSE 6PK | 6 | 750ml | 4
44381400 | CDB | CDB | CDB MZ | 2016 | [PHONE] | CDB MZ 6PK 750M 2016 | CDB MZ 6PK | 6 | 750ml | 4
44381399 | CDB | CDB | CDB MZ | 2017 | [PHONE] | CDB MZ 6PK 750M 2017 | CDB MZ 6PK | 6 | 750ml | 4
44381401 | CDB | CDB | CDB MZ | 2018 | [PHONE] | CDB MZ 6PK 750M 2018 | CDB MZ 6PK | 6 | 750ml | 4
44381402 | CDB | CDB | CDB MZ | 2019 | [PHONE] | CDB MZ 6PK 750M 2019 | CDB MZ 6PK | 6 | 750ml | 4
44382398 | CDB | CDB | CDB PN | 2015 | [PHONE] | CDB PN 6PK 750M 2015 | CDB PN 6PK | 6 | 750ml | 4
44382399 | CDB | CDB | CDB PN | 2016 | [PHONE] | CDB PN 6PK 750M 2016 | CDB PN 6PK | 6 | 750ml | 4
44382400 | CDB | CDB | CDB PN | 2018 | [PHONE] | CDB PN 6PK 750M 2018 | CDB PN 6PK | 6 | 750ml | 4
44382401 | CDB | CDB | CDB PN | 2019 | [PHONE] | CDB PN 6PK 750M 2019 | CDB PN 6PK | 6 | 750ml | 4
44367399 | CDB | CDB | CDB  DZ | 2017 | [PHONE] | CDB  DZ 6PK 750M 2017 | CDB DZ 6PK | 6 | 750ml | 4
44367400 | CDB | CDB | CDB  DZ | 2018 | [PHONE] | CDB  DZ 6PK 750M 2018 | CDB DZ 6PK | 6 | 750ml | 4
44367398 | CDB | CDB | CDB  DZ | 2016 | [PHONE] | CDB  DZ 6PK NL 750M 2016 | CDB DZ 6PK | 6 | 750ml | 4
44367396 | CDB | CDB | CDB  DZ | 2013 | [PHONE] | CDB  DZ 6PK OL 750M 2013 | CDB DZ 6PK | 6 | 750ml | 4
44367397 | CDB | CDB | CDB  DZ | 2014 | [PHONE] | CDB  DZ 6PK OL 750M 2014 | CDB DZ 6PK | 6 | 750ml | 4
44368396 | CDB | CDB | CDB  BLANC | 2016 | [PHONE] | CDB  BLANC 6PK 750M 2016 | CDB BRUT BLANC 6PK | 6 | 750ml | 4
44368397 | CDB | CDB | CDB  BLANC | 2018 | [PHONE] | CDB  BLANC 6PK 750M 2018 | CDB BRUT BLANC 6PK | 6 | 750ml | 4
48384396 | CAM | CAM | [NAME] | 2017 | [PHONE] | [NAME]750M 2017 | [NAME] | 12 | 750ml | 4
48384397 | CAM | CAM | [NAME] | 2018 | [PHONE] | [NAME]750M 2018 | [NAME] | 12 | 750ml | 4
48384398 | CAM | CAM | [NAME] | 2019 | [PHONE] | [NAME]750M 2019 | [NAME] | 12 | 750ml | 4
48384399 | CAM | CAM | [NAME] | 2020 | [PHONE] | [NAME]750M 2020 | [NAME] | 12 | 750ml | 4
48384400 | CAM | CAM | [NAME] | 2021 | [PHONE] | [NAME]750M 2021 | [NAME] | 12 | 750ml | 4
48384401 | CAM | CAM | [NAME] | 2022 | [PHONE] | [NAME]750M 2022 | CAM ROSE | 12 | 750ml | 4
48387396 | CAM | CAM | CAM RED BLND | 0000 | [PHONE] | CAM GIOME RED | CAM RED | 12 | 750ml | 4
48386396 | CAM | CAM | CAM TREBBIANO | 0000 | [PHONE] | [NAME]  750M | CAM TREBBIANO | 12 | 750ml | 4
48385396 | CAM | CAM | [NAME] | 0000 | [PHONE] | [NAME]  750M | [NAME] | 12 | 750ml | 4
98767396 | CAM | CAM | CAM PRESTIGE | 0000 | [PHONE] | CAM PRESTIGE 6PK 750M | CAM PRESTIGE WHITE 6PK | 6 | 750ml | 4
78720396 | RAM WILLAMETTE | RAM | RAM CHARD | 2013 | [PHONE] | RAM CHARD  750M 2013 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4 | (M) Manual
78720397 | RAM WILLAMETTE | RAM | RAM CHARD | 2014 | [PHONE] | RAM CHARD SCRW CP 750M 2014 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4 | (M) Manual
78720398 | RAM WILLAMETTE | RAM | RAM CHARD | 2015 | [PHONE] | RAM CHARD SCRW CP 750M 2015 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4 | (M) Manual
78720402 | RAM WILLAMETTE | RAM | RAM CHARD | 2021 | [PHONE] | RAM  WLM VLY CHARD  750M 2021 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4
78720399 | RAM WILLAMETTE | RAM | RAM CHARD | 2018 | [PHONE] | RAM  WLM VLY CHARD NL SCRW  750M 2018 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4 | (M) Manual
78720400 | RAM WILLAMETTE | RAM | RAM CHARD | 2019 | [PHONE] | RAM  WLM VLY CHARD NL SCRW  750M 2019 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4
78720401 | RAM WILLAMETTE | RAM | RAM CHARD | 2020 | [PHONE] | RAM  WLM VLY CHARD NL SCRW  750M 2020 | RAM CHARD WILLAMETTE VLY SCRW | 12 | 750ml | 4
78750396 | RAM WILLAMETTE | RAM | RAM DUNDEE KNUDSEN P NOIR | 2019 | [PHONE] | RAM DUNDEE KNUDSEN P NOIR  750M 2019 | RAM P NOIR DUNDEE KNUDSEN | 12 | 750ml | 4
78731403 | RAM WILLAMETTE | RAM | RAM  P NOIR | 0000 | [PHONE] | RAM  P NOIR +14 SCRW CP 750M | RAM P NOIR GRAVEL RD SCRW NV | 12 | 750ml | 4 | (E) Everyday
78731401 | RAM WILLAMETTE | RAM | RAM  P NOIR | 2017 | [PHONE] | RAM  P NOIR +14 SCRW CP 750M 2017 | RAM P NOIR  SCW CP | 12 | 750ml | 4
78731402 | RAM WILLAMETTE | RAM | RAM  P NOIR | 2018 | [PHONE] | RAM  P NOIR +14 SCRW CP 750M 2018 | RAM P NOIR GRAVEL RD SCRW CAP | 12 | 750ml | 4 | (D) Discontinued
78731397 | RAM WILLAMETTE | RAM | RAM  P NOIR | 2013 | [PHONE] | RAM  P NOIR SCRW CP NL 750M 2013 | RAM P NOIR  SCW CP | 12 | 750ml | 4
78731396 | RAM WILLAMETTE | RAM | RAM  P NOIR | 2012 | [NAME] | RAM WLM VLY P NOIR OL 750M 2012 | RAM P NOIR WILLAM VLY SCRW CP | 12 | 750ml | 4
78725402 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2019 | [PHONE] | RAM MARSH P NOIR  750M 2019 | RAM P NOIR MARSH EST | 12 | 750ml | 4
78725403 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2021 | [PHONE] | RAM MARSH P NOIR  750M 2021 | RAM P NOIR MARSH EST | 12 | 750ml | 4
78725398 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2015 | [PHONE] | RAM MARSH P NOIR +14 6PK SC 750M 2015 | RAM P NOIR MARSH EST SCW +14 | 6 | 750ml | 4 | (M) Manual
78725399 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2016 | [PHONE] | RAM MARSH P NOIR +14 6PK SC 750M 2016 | RAM P NOIR MARSH EST SCW +14 | 6 | 750ml | 4 | (M) Manual
78725400 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2019 | [PHONE] | RAM MARSH P NOIR +14 6PK SC 750M 2019 | RAM P NOIR MARSH EST SCW +14 | 6 | 750ml | 4 | (M) Manual
78725396 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2012 | [PHONE] | RAM MARSH P NOIR 6PK 750M 2012 | RAM P NOIR MARSH EST SCRW 6PK | 6 | 750ml | 4 | (M) Manual
78725397 | RAM WILLAMETTE | RAM | RAM MARSH P NOIR | 2013 | [PHONE] | RAM MARSH P NOIR 6PK 750M 2013 | RAM P NOIR MARSH EST SCRW 6PK | 6 | 750ml | 4 | (M) Manual
78727400 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2017 | [PHONE] | RAM PVT P NOIR 6PK +14 750M 2017 | RAM P NOIR PVT +14 6PK | 6 | 750ml | 4
78727401 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2018 | [PHONE] | RAM PVT P NOIR 6PK +14 750M 2018 | RAM P NOIR PVT +14 6PK | 6 | 750ml | 4
78727396 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2012 | [PHONE] | RAM PVT P NOIR 6PK 750M 2012 | RAM P NOIR PVT SCRW 6PK | 6 | 750ml | 4 | (A) Allocated
78727397 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2013 | [PHONE] | RAM PVT P NOIR 6PK 750M 2013 | RAM P NOIR PVT SCRW 6PK | 6 | 750ml | 4 | (A) Allocated
78727402 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2019 | [PHONE] | RAM PVT P NOIR 6PK SCRW 750M 2019 | RAM P NOIR PVT SCRW CP | 6 | 750ml | 4
78727398 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2014 | [PHONE] | RAM PVT P NOIR 6PK SCRW CP 750M 2014 | RAM P NOIR PVT SCRW +14 | 6 | 750ml | 4 | (A) Allocated
78727399 | RAM WILLAMETTE | RAM | RAM PVT P NOIR | 2016 | [PHONE] | RAM PVT P NOIR 6PK SCRW CP 750M 2016 | RAM P NOIR PVT SCRW +14 | 6 | 750ml | 4 | (A) Allocated
78729404 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2021 | [PHONE] | RAM STK P NOIR  750M 2021 | RAM P NOIR STK | 12 | 750ml | 4
78729401 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2018 | [PHONE] | RAM STK P NOIR +14 STELVN 750M 2018 | RAM P NOIR STK SCRW CP+14 | 12 | 750ml | 4 | (M) Manual
78729402 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2019 | [PHONE] | RAM STK P NOIR +14 STELVN 750M 2019 | RAM P NOIR STK SCRW CP+14 | 12 | 750ml | 4
78729403 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2021 | [PHONE] | RAM STK P NOIR +14 STELVN 750M 2021 | RAM P NOIR STK +14 | 12 | 750ml | 4
78729396 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2012 | [PHONE] | RAM STK P NOIR 6PK 750M 2012 | RAM P NOIR STK SCRW CP 6P | 6 | 750ml | 4 | (M) Manual
78729397 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2013 | [PHONE] | RAM STK P NOIR 6PK SCRW CP 750M 2013 | RAM P NOIR STK SCRW CP 6P | 6 | 750ml | 4 | (M) Manual
78729398 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2014 | [PHONE] | RAM STK P NOIR 6PK SCRW CP 750M 2014 | RAM P NOIR STK SCRW CP 6P | 6 | 750ml | 4 | (M) Manual
78729399 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2017 | [PHONE] | RAM STK P NOIR 6PK SCRW CP 750M 2017 | RAM P NOIR STK SCRW CP 6P | 6 | 750ml | 4 | (M) Manual
78729400 | RAM WILLAMETTE | RAM | RAM STK P NOIR | 2018 | [PHONE] | RAM STK P NOIR 6PK SCRW CP 750M 2018 | RAM P NOIR STK SCRW CP 6P | 6 | 750ml | 4 | (M) Manual
78724396 | RAM WILLAMETTE | RAM | RAM WLM VLY RMS BRUT ROSE | 2019 | [PHONE] | RAM WLM VLY RMS BRUT ROSE 6PK 750M 2019 | RAM RMS BRUT ROSE WLM VLY | 6 | 750ml | 4
78721396 | RMS | RMS | RMS P NOIR CHARD BRUT | 2013 | [PHONE] | RMS P NOIR CHARD BRUT 6PK 750M 2013 | RAM BRUT SPRK WILLAMETTE VLY | 6 | 750ml | 4
78721397 | RMS | RMS | RMS P NOIR CHARD BRUT | 2015 | [PHONE] | RMS P NOIR CHARD BRUT 6PK 750M 2015 | RAM BRUT SPRK WILLAMETTE VLY | 6 | 750ml | 4
78721398 | RMS | RMS | RMS P NOIR CHARD BRUT | 2016 | [PHONE] | RMS P NOIR CHARD BRUT 6PK 750M 2016 | RAM BRUT SPRK WILLAMETTE VLY | 6 | 750ml | 4
78721399 | RAM WILLAMETTE | RMS | RAM RMS P NOIR CHARD BRUT | 2019 | [PHONE] | RAM RMS P NOIR CHARD BRUT 6PK 750M 2019 | RAM RMS BRUT PNR CHRD WLM VLY | 6 | 750ml | 4
47540397 | TORR | TORR | TORR P GRIGIO | 0000 | [PHONE] | TORR VENETO P GRIGIO NL 750M | TORR P GRIGIO VENETO NL | 12 | 750ml | 4
47540398 | TORR | TORR | TORR P GRIGIO | 0000 | [PHONE] | TORR VENETO P GRIGIO NL W/SCARVES 750M | TORR P GRIGIO W/SCARVES | 12 | 750ml | 4
47541396 | TORR | TORR | TORR PROSECCO | 0000 | [PHONE] | TORR PROSECCO  750M | TORR PROSECCO | 12 | 750ml | 4
47541397 | TORR | TORR | TORR PROSECCO | 0000 | [PHONE] | TORR PROSECCO 6PK OLD UPC 750M | TORR PROSECCO 6PK | 6 | 750ml | 4
47541398 | TORR | TORR | TORR PROSECCO | 0000 | [PHONE] | TORR PROSECCO GFT 750M | TORR PROSECCO GFT | 12 | 750ml | 4
47541399 | TORR | TORR | TORR PROSECCO | 0000 | [PHONE] | TORR PROSECCO W/SCARVES 750M | TORR PROSECCO W/SCARVES | 12 | 750ml | 4
47539396 | TORR | TORR | TORR PROSECCO ROSE | 2020 | [PHONE] | TORR PROSECCO ROSE  750M 2020 | TORR PROSECCO ROSE | 12 | 750ml | 4
47539398 | TORR | TORR | TORR PROSECCO ROSE | 2022 | [PHONE] | TORR PROSECCO ROSE  750M 2022 | TORR PROSECCO ROSE | 12 | 750ml | 4
47539397 | TORR | TORR | TORR PROSECCO ROSE | 2020 | [PHONE] | TORR PROSECCO ROSE W/SCARVES 750M 2020 | TORR PROS ROSE W/SCARVES | 12 | 750ml | 4