Spreadsheet: 743024d1628171024-vlookup-returning-n-a-eh_discounter_index-match
Sheet: PV Exra

 | Total STORES01 | Total Hard Discounters | Blue | Yellow
Total PRODUCTS | 2760 | 2760 | 1439 | 1320
MR K     ALM         SL      6 | 12 | 12 | 6 | 5
MR K     ALMN BTNBMN SC      5 | 0 | 0 | 0 | 0
MR K     ANG         CC      1 | 0 | 0 | 0 | 0
MR K     ANG         SL      6 | 6 | 6 | 2 | 3
MR K     ANG SNKPK   SL      2 | 0 | 0 | 0 | 0
MR K     ANG SNKPK   SL      4 | 0 | 0 | 0 | 0
MR K     ANG SNKPK   SL      6 | 0 | 0 | 0 | 0
MR K     ANG SNKPK   SL      8 | 62 | 62 | 14 | 48
MR K     ANG SNKPK   SL      9 | 0 | 0 | 0 | 0
MR K     ANG SNKPK   SL     12 | 0 | 0 | 0 | 0
MR K     ANG SNKPK   SL    4+4 | 0 | 0 | 0 | 0
MR K     AP          SFP     6 | 6 | 6 | 4 | 2
MR K     AP          SFP     6 | 0 | 0 | 0 | 0
MR K     AP          SFP     6 | 0 | 0 | 0 | 0
MR K     AP          SFP     6 | 0 | 0 | 0 | 0
MR K     AP          SFP     6 | 1 | 1 | 0 | 1
MR K     AP          SFP     6 | 1 | 1 | 1 | 0
MR K     AP          SFP   6+2 | 0 | 0 | 0 | 0
MR K     AP+BLCRT    SFP     6 | 7 | 7 | 2 | 5
MR K     AP+BLKCRNT  SFP   6+2 | 0 | 0 | 0 | 0
MR K     APL PIE     CC      1 | 0 | 0 | 0 | 0
MR K     APLPRCSTCRMBST      6 | 3 | 3 | 0 | 3
MR K     AST         CC     12 | 0 | 0 | 0 | 0
MR K     AST FT      SFP     6 | 5 | 5 | 3 | 3
MR K     AST JAM     ST      6 | 0 | 0 | 0 | 0
MR K     AST MN BKWL ST      9 | 6 | 6 | 6 | 0
MR K     AST MNI FT  SFP     9 | 2 | 2 | 2 | 0
MR K     AST SPNGMNI ST      9 | 0 | 0 | 0 | 0
MR K     AWSM APL    SL      6 | 0 | 0 | 0 | 0
MR K     BKWL        LT      1 | 0 | 0 | 0 | 0
MR K     BKWL        SL      6 | 9 | 9 | 8 | 1
MR K     BKWL        SL    6+2 | 0 | 0 | 0 | 0
MR K     BKWL        ST      8 | 0 | 0 | 0 | 0
MR K     BKWL        ST     16 | 0 | 0 | 0 | 0
MR K     BMBLBEESNKPKSL      8 | 0 | 0 | 0 | 0
MR K     BMBLBEESNKPKSL      9 | 0 | 0 | 0 | 0
MR K     BNAMLKSNKPK SL      4 | 0 | 0 | 0 | 0
MR K     BNF SNKPK   SL      4 | 0 | 0 | 0 | 0
MR K     BNMLKSKSNKPKSL      8 | 0 | 0 | 0 | 0
MR K     BNMLKSKSNKPKSL      9 | 0 | 0 | 0 | 0
MR K     BTNB        SC      5 | 175 | 175 | 146 | 29
MR K     BTNB        WC      1 | 19 | 19 | 1 | 17
MR K     BTNB        WC      1 | 0 | 0 | 0 | 0
MR K     CFE SPG     WC      1 | 0 | 0 | 0 | 0
MR K     CHC         SL      6 | 3 | 3 | 3 | 1
MR K     CHC MUDPIES ST      6 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL      2 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL      4 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL      6 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL      6 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL      8 | 41 | 41 | 1 | 40
MR K     CHC SNKPK   SL      9 | 0 | 0 | 0 | 0
MR K     CHC SNKPK   SL    4+4 | 0 | 0 | 0 | 0
MR K     CHC SPG     WC      1 | 0 | 0 | 0 | 0
MR K     CHC WHRL    SC      4 | 0 | 0 | 0 | 0
MR K     CHC WHRL    SC      6 | 0 | 0 | 0 | 0
MR K     CHC+CMLSNKPKSL      6 | 0 | 0 | 0 | 0
MR K     CHC+CRML+PCNSL      4 | 0 | 0 | 0 | 0
MR K     CHC+MNT FNC SC      8 | 2 | 2 | 1 | 1
MR K     CHC+ORG FNC SC      8 | 1 | 1 | 1 | 0
MR K     CHCP        SL      6 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   FLP     1 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   ST      2 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   ST      6 | 15 | 15 | 8 | 8
MR K     CHRY BKWL   ST      6 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   ST      6 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   ST      6 | 2 | 2 | 0 | 2
MR K     CHRY BKWL   ST      6 | 0 | 0 | 0 | 0
MR K     CHRY BKWL   ST    6+2 | 0 | 0 | 0 | 0
MR K     CHRYBKWL    CC      1 | 0 | 0 | 0 | 0
MR K     CHRYBKWL SQ FLP     3 | 0 | 0 | 0 | 0
MR K     CHVNMLKSNKPKSL      4 | 0 | 0 | 0 | 0
MR K     CKTL FNC    SC      8 | 0 | 0 | 0 | 0
MR K     CML SNKPK   SL      4 | 0 | 0 | 0 | 0
MR K     CNTRY       SL      6 | 4 | 4 | 1 | 3
MR K     CNTRY       SL      8 | 0 | 0 | 0 | 0
MR K     CNTRY       SL     16 | 0 | 0 | 0 | 0
MR K     CNTRY       SL    6+2 | 0 | 0 | 0 | 0
MR K     CRBOROTSNKPKSL      4 | 0 | 0 | 0 | 0
MR K     CRNOROTSNKPKSL      2 | 0 | 0 | 0 | 0
MR K     CRT         SL      6 | 1 | 1 | 1 | 0
MR K     CRT+WLNT    SL      6 | 0 | 0 | 0 | 0
MR K     DBL CHC     SR      1 | 0 | 0 | 0 | 0
MR K     DCHCNOTSNKPKSL      4 | 0 | 0 | 0 | 0
MR K     DF MINC     MP      6 | 149 | 149 | 7 | 142
MR K     DRAGON      SL      6 | 0 | 0 | 0 | 0
MR K     EST CHC WHR SC      6 | 2 | 2 | 2 | 0
MR K     EST LMN BKW ST      6 | 1 | 1 | 1 | 1
MR K     EST PNK FNC SC      8 | 0 | 0 | 0 | 0
MR K     ESTCHORNGWHRSC      6 | 0 | 0 | 0 | 0
MR K     ESTHTXSPCRSNSL      3 | 0 | 0 | 0 | 0
MR K     ESTHTXSPCRSNSL      6 | 45 | 45 | 4 | 41
MR K     ESTLMNELDFLWSL      6 | 0 | 0 | 0 | 0
MR K     ESTLMNVNSWHRSC      6 | 118 | 118 | 117 | 1
MR K     ESTORNGLMN  SL      6 | 0 | 0 | 0 | 0
MR K     ESTR MZ+FRT SL      6 | 0 | 0 | 0 | 0
MR K     ESTR ST CLM SL      6 | 0 | 0 | 0 | 0
MR K     ESTRIPLCHC  SL      6 | 0 | 0 | 0 | 0
MR K     ESTRVNLAFNC SC      8 | 1 | 1 | 1 | 0
MR K     ETONMESSBKWLST      6 | 0 | 0 | 0 | 0
MR K     FLAMINGO    SL      6 | 0 | 0 | 0 | 0
MR K     FRNC FNC    SC      8 | 62 | 62 | 9 | 53
MR K     FRST FRT    SL      6 | 0 | 0 | 0 | 0
MR K     FT          WC      1 | 7 | 7 | 4 | 2
MR K     GLDNSYRP SQ FLP     3 | 0 | 0 | 0 | 0
MR K     GNGBD WHRL  SC      6 | 0 | 0 | 0 | 0
MR K     HLWANGSNKPK SL     12 | 100 | 100 | 0 | 100
MR K     HLWN CHC    ST      6 | 0 | 0 | 0 | 0
MR K     HLWN VNL FNCSC      8 | 0 | 0 | 0 | 0
MR K     HLWNCHC+LIMESL      6 | 0 | 0 | 0 | 0
MR K     HLWNCHC+MLW SL      6 | 31 | 31 | 0 | 31
MR K     HLWNCHC+VNL SL      8 | 6 | 6 | 4 | 2
MR K     HLWNCHCSLIMESL      6 | 0 | 0 | 0 | 0
MR K     HLWNCHCSLIMESL     16 | 0 | 0 | 0 | 0
MR K     HLWNFNDSHFNCSC      8 | 81 | 81 | 1 | 80
MR K     HLWNORFNDFNCSC      8 | 0 | 0 | 0 | 0
MR K     HLWNTFE+APL SL      6 | 0 | 0 | 0 | 0
MR K     HLWNWITCHFNCSC      8 | 0 | 0 | 0 | 0
MR K     HLWSPANGSNKPSL     16 | 0 | 0 | 0 | 0
MR K     HLWTFTRRWHRLSC      6 | 116 | 116 | 4 | 112
MR K     HNYCMB FNC  SC      8 | 0 | 0 | 0 | 0
MR K     ICD MINC    MP      2 | 0 | 0 | 0 | 0
MR K     ICD MINC    MP      6 | 0 | 0 | 0 | 0
MR K     ICD MINC    MP      6 | 162 | 162 | 4 | 158
MR K     JAM+CST     SL      6 | 0 | 0 | 0 | 0
MR K     LMN         SL      6 | 0 | 0 | 0 | 0
MR K     LMN         SR      1 | 0 | 0 | 0 | 0
MR K     LMN         ST      4 | 0 | 0 | 0 | 0
MR K     LMN FNC     SC      8 | 1 | 1 | 0 | 1
MR K     LMN LYR     CC      1 | 0 | 0 | 0 | 0
MR K     LMN LYR     SL      6 | 11 | 11 | 8 | 3
MR K     LMN SNKPK   SL    4+4 | 0 | 0 | 0 | 0
MR K     LMN SPG     WC      1 | 0 | 0 | 0 | 0
MR K     LMNFRNC FNC SC      8 | 66 | 66 | 3 | 62
MR K     LMNLYR SNKPKSL      2 | 0 | 0 | 0 | 0
MR K     LMNLYR SNKPKSL      4 | 0 | 0 | 0 | 0
MR K     LMNLYR SNKPKSL      6 | 0 | 0 | 0 | 0
MR K     LMNLYR SNKPKSL      8 | 43 | 43 | 4 | 40
MR K     LMNLYRSNKPK SL      9 | 0 | 0 | 0 | 0
MR K     MINC        MP      6 | 0 | 0 | 0 | 0
MR K     MINC        MP      6 | 0 | 0 | 0 | 0
MR K     MINC MNI    MP      9 | 0 | 0 | 0 | 0
MR K     MLNR WHRL   SC      6 | 0 | 0 | 0 | 0
MR K     ORNG+LMN    SL      6 | 0 | 0 | 0 | 0
MR K     PCH FNC     SC      8 | 0 | 0 | 0 | 0
MR K     PCH+CRM     SL      6 | 0 | 0 | 0 | 0
MR K     RCKN RSP    SL      6 | 0 | 0 | 0 | 0
MR K     RD CHC+RSP  SL      6 | 0 | 0 | 0 | 0
MR K     RD HNYCMB   SL      6 | 0 | 0 | 0 | 0
MR K     RDAPLBTNBMN SC      5 | 0 | 0 | 0 | 0
MR K     RDCHCFDGWHRLSC      6 | 0 | 0 | 0 | 0
MR K     RDRSP+VNFNC SC      8 | 0 | 0 | 0 | 0
MR K     ROALDAHSNKPKSL      6 | 0 | 0 | 0 | 0
MR K     RSP         SR      1 | 0 | 0 | 0 | 0
MR K     RSP         ST      4 | 0 | 0 | 0 | 0
MR K     RSP RPL     SL      6 | 0 | 0 | 0 | 0
MR K     RSPJMBTRVNWHSC      6 | 0 | 0 | 0 | 0
MR K     RSPJMCRMVNWHSC      6 | 0 | 0 | 0 | 0
MR K     RSPJMCRMVNWHSC      6 | 0 | 0 | 0 | 0
MR K     RSPJMLMNVNWHSC      6 | 1 | 1 | 1 | 0
MR K     RSPJMSPG    WC      1 | 0 | 0 | 0 | 0
MR K     RSPJMVNLVNWHSC      6 | 0 | 0 | 0 | 0
MR K     RSPWCHCSPG  WC      1 | 0 | 0 | 0 | 0
MR K     RYLWBRDLFNC SC      8 | 0 | 0 | 0 | 0
MR K     SLTDCRCHWHRLSC      4 | 0 | 0 | 0 | 0
MR K     SMRSTCHSVNWHSC      6 | 0 | 0 | 0 | 0
MR K     SMRTRFLSNKPKSL      6 | 0 | 0 | 0 | 0
MR K     SMSHNG STRW SL      6 | 0 | 0 | 0 | 0
MR K     STRCRFRNCFNCSC      8 | 0 | 0 | 0 | 0
MR K     STRMLSKSNKPKSL      8 | 0 | 0 | 0 | 0
MR K     STRMLSKSNKPKSL      9 | 0 | 0 | 0 | 0
MR K     STRW+CRMFNC SC      8 | 143 | 143 | 143 | 0
MR K     STRWMLKSNKPKSL      4 | 0 | 0 | 0 | 0
MR K     TIGERSNKPK  SL      8 | 0 | 0 | 0 | 0
MR K     TIGERSNKPK  SL      9 | 0 | 0 | 0 | 0
MR K     TRCL        LT      1 | 0 | 0 | 0 | 0
MR K     TRFL BKWL   ST      6 | 2 | 2 | 1 | 1
MR K     UNICORN     SL      6 | 145 | 145 | 128 | 18
MR K     UNICORN     SL      8 | 0 | 0 | 0 | 0
MR K     UNICORNVNFNCSC      8 | 0 | 0 | 0 | 0
MR K     VIC         SL      6 | 1 | 1 | 1 | 0
MR K     VIC SPG     WC      1 | 0 | 0 | 0 | 0
MR K     VLFNDFNCSTW SC      8 | 0 | 0 | 0 | 0
MR K     VLTSTRWVNSWHRSC     6 | 0 | 0 | 0 | 0
MR K     VNS WHRL    CC      1 | 0 | 0 | 0 | 0
MR K     VNS WHRL    SC      6 | 49 | 49 | 7 | 42
MR K     VNS WHRL    SC    6+2 | 0 | 0 | 0 | 0
MR K     XMCHORGNGWRLSC      6 | 102 | 102 | 90 | 12
MR K     XMGNBDVNSWRLSC      6 | 0 | 0 | 0 | 0
MR K     XMS AP      SL      6 | 0 | 0 | 0 | 0
MR K     XMS AST     SC     12 | 0 | 0 | 0 | 0
MR K     XMS ELF APL SL      6 | 0 | 0 | 0 | 0
MR K     XMS ICD FT  SL      6 | 402 | 402 | 346 | 56
MR K     XMS MINC    SL      6 | 18 | 18 | 0 | 18
MR K     XMS STL     SL      6 | 0 | 0 | 0 | 0
MR K     XMSCANDYCANESL      8 | 0 | 0 | 0 | 0
MR K     XMSDFASTMINCMP     12 | 0 | 0 | 0 | 0
MR K     XMSFROSTYFNCSC      8 | 52 | 52 | 0 | 52
MR K     XMSFSTVBKWL ST      6 | 214 | 214 | 212 | 2
MR K     XMSFT SNKPK SL      6 | 0 | 0 | 0 | 0
MR K     XMSICDFT    SL      6 | 0 | 0 | 0 | 0
MR K     XMSICDFT    SL      9 | 0 | 0 | 0 | 0
MR K     XMSIRSHCMFNCSC      8 | 0 | 0 | 0 | 0
MR K     XMSRNDCHCRMLSL      8 | 70 | 70 | 3 | 68
MR K     XMSRUMRAISN SL      6 | 0 | 0 | 0 | 0
MR K     XMSSTMGNGCHCSL      6 | 0 | 0 | 0 | 0
MR K     XMSWNTRWHRL SC      6 | 160 | 160 | 110 | 50
MR K     XRM+RSNSNKPKSL      6 | 0 | 0 | 0 | 0
MR K GF  ALM         SL      4 | 0 | 0 | 0 | 0
MR K GF  AP LF       WC      1 | 0 | 0 | 0 | 0
MR K GF  CHC BRW     SL      4 | 0 | 0 | 0 | 0
MR K GF  CHRYBKWL LF WC      1 | 0 | 0 | 0 | 0
MR K GF  CHRYBKWLMNI ST      6 | 0 | 0 | 0 | 0
MR K GF  CNTRY       SL      4 | 0 | 0 | 0 | 0
MR K GF  GNG+LMN LF  WC      1 | 0 | 0 | 0 | 0
MR K GF  MINC        MP      4 | 0 | 0 | 0 | 0
MR K LS  CHC SNKPK   SL      6 | 3 | 3 | 3 | 0
MR K LS  LMN SNKPK   SL      6 | 7 | 7 | 7 | 0
MR K LS ANG SNKPK  SL        6 | 7 | 7 | 7 | 0