Spreadsheet: 156052d1337164214-extracting-multiple-records-from-one-lookup-value-fz-reporting-16-may-2012
Sheet: Mini

ENTITY - 30ML - Mini
 | Product Name | FINISH PRODUCT |  |  | [NAME] |  |  |  | CAP |  |  |  | UNIT CARTONS |  |  |  |  | Concentrate
Sr. No. | VARIANT NAME |  | FG Stock | To Produce | STOCK | ON ORDER | Stock after Production & On Order |  | COLOUR | STOCK | ON ORDER | Stock after Production & On Order |  | STOCK | ON ORDER | Stock after Production & On Order |  | STOCK | ON ORDER | Stock after Production & On Order | Supplier
1 | GREEN TEEN | EN/GRT/W/30/EDT |  |  |  |  |  | CAP/BH/MI/WHIT/30/EN/W | WHITE |  |  |  | UCN/UT/MI/GRT/30/EN/W |  |  |  | CON/GR/29/4280/GT/EARDEN/W
 | SHINE SO BRIGHT | EN/SSB/W/30/EDT |  |  |  |  |  | CAP/BH/MI/TRWH/30/EN/W | NATURAL |  |  |  | UCN/UT/MI/SSB/30/EN/W |  |  |  | CON/VM/BRTG/BRTCRYSTL/VRSCE/W |  |  |  | V Mane Fils / Already On Order in Admire-Shine So Bright
 | [NAME] | EN/LBZ/W/30/EDT |  |  |  |  |  | CAP/BH/MI/BLUE/30/EN/W | BLUE |  |  |  | UCN/UT/MI/LBZ/30/EN/W |  |  |  | CON/GF/29119/LPKNZO/KENZO/W |  |  |  | Grasse French / Already On Order in Lom-Keen
 | ALWAYS SHINE | EN/ALW/W/30/EDT |  |  |  |  |  |  | WHITE |  |  |  | UCN/UT/MI/ALW/30/EN/W |  |  |  | CON/AR/VESH/DIORADSH/DIOR/W |  |  |  | Argeville / Already On Order in Dream-Just Addiction
 | ECLIPSE DU TEMPS | EN/EDT/W/30/EDT |  |  |  |  |  |  | NATURAL |  |  |  | UCN/UT/MI/EDT/30/EN/W |  |  |  | CON/AR/ETNC/ECLAT/LANVIN/W |  |  |  | Argeville / Already On Order in Triangle-Nave
 | DELISH | EN/DEL/W/30/EDT |  |  |  |  |  |  | WHITE |  |  |  | UCN/UT/MI/DEL/30/EN/W |  |  |  | CON/ES/BOLC/DLECS/DKNY/W |  |  |  | Essence / Already On Order in Helix-Delish
 | LIFE AND LOVE | EN/LIF/W/30/EDT |  |  |  |  |  |  | WHITE |  |  |  | UCN/UT/MI/LIF/30/EN/W |  |  |  | CON/AR/GRCS/ILOV/MSCHNO/W |  |  |  | Argeville / Already On Order in Helix-Life & Love
 | WHITE CLOUDS (FROSTED) | EN/WTC/W/30/EDT |  |  |  |  |  |  | BLUE |  |  |  | UCN/UT/MI/WTC/30/EN/W |  |  |  | CON/AR/COLO/LICL/MSCHNO/W |  |  |  | Argeville / Already On Order in Helix-Eclipse
 | LEAF IN RED | EN/LFR/W/30/EDT |  |  |  |  |  |  | NATURAL |  |  |  | UCN/UT/MI/LFR/30/EN/W |  |  |  | CON/AR/ANDR/INRED/ARMNBSI/W |  |  |  | Argeville / Already On Order in Dream-Red & White
 | WEEK IN (FROSTED) | EN/WEK/W/30/EDT |  |  |  |  |  |  | WHITE |  |  |  | UCN/ut/MI/WEK/30/EN/W |  |  |  | CON/GR/30/4676/WKEND/BRBERY/W |  |  |  | Grasse French / Already On Order in Triangle-Week In
 | ENCHANT SHINE | EN/ENC/W/30/EDT |  |  |  |  |  |  | BLUE |  |  |  | UCN/ut/MI/ENC/30/EN/W |  |  |  | CON/AR/SPRK/INC2SH/SFRGMO/W |  |  |  | [NAME]
 | FUJI | EN/FUJ/W/30/EDT |  |  |  |  |  | CAP/BH/MI/BLCK/30/EN/W | BLACK |  |  |  | UCN/UT/MI/FUJ/30/EN/W |  |  |  | CON/AR/BRMD/FIDJI/GYLROCH/W |  |  |  | Argeville / Already On Order in Triangle-Fuji
 | HYPNOTISME | EN/HYP/W/30/EDT |  |  |  |  |  |  | WHITE |  |  |  | UCN/UT/MI/HYP/30/EN/W |  |  |  | CON/GR/30/5608/HYPN/LNCOM/W |  |  |  | Already on Order in Lom-Purpose
 | CLIMATIC | EN/CLT/W/30/EDT |  |  |  |  |  |  | NATURAL |  |  |  | UCN/UT/MI/CLT/30/EN/W |  |  |  | CON/ES/CARL/CLIMT/LNCOM/W |  |  |  | Essence / Already On Order in Triangle-Climatic
 | MAGICAL NOYAU | EN/MAG/W/30/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/ut/MI/MAG/30/EN/W |  |  |  | CON/ES/MARB/MGCNR/LNCOM/W |  |  |  | Essence / Already On Order in Triangle-Magic Women
 | Total
 |  | BOT/PG/MI/CL/30/EN/W |  | PLAIN
 |  | BOT/PG/MI/FR/30/EN/W |  | FROSTED
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/GRT/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/SSB/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LBZ/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/ALW/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/EDT/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/DEL/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LIF/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/WTC/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LFR/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/WEK/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/ENC/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/FUJ/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/HYP/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/CLT/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/MAG/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/MI/MAG/30/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/GRT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/SSB/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/LBZ/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/ALW/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/EDT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/DEL/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/LIF/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/WTC/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/LFR/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/MI/WEK/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/MI/ENC/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/FUJ/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/HYP/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/MI/CLT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/MI/MAG/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/GRT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/SSB/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LBZ/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/ALW/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/EDT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/DEL/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LIF/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/WTC/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/LFR/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/WEK/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/ENC/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/FUJ/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/HYP/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/CLT/30/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/MI/MAG/30/EN/W/FMF