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

ENTITY - 50 ML - HELIX
 |  |  |  |  |  |  |  |  | 0
 |  |  | FINISH PRODUCT |  |  | BOTTLE |  |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | 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 | DECODE | EN/DEC/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/BLCK/50/EN/W | BLACK |  |  |  | UCN/EM/HE/DEC/50/EN/W |  |  |  | CON/AF/22142/ARMCOD/GOARM/W |  |  |  | [NAME]
2 | BE PRECISE | EN/BPR/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/TRPP/50/EN/W | TRANA PURPLE |  |  |  | UCN/EM/HE/BPR/50/EN/W |  |  |  | CON/AF/Z22143/BYNDPRDSE/W |  |  |  | Grasse French
3 | E | EN/E03/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/RED/50/EN/W | RED |  |  |  | UCN/EM/HE/E03/50/EN/W |  |  |  | CON/AR/VPRE/S/ESCADA/W |  |  |  | [NAME]
4 | ECLIPSE | EN/ECP/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/SLVR/50/EN/W | SILVER |  |  |  | UCN/EM/HE/ECP/50/EN/W |  |  |  | CON/AR/ETNC/ECLAT/LANVIN/W |  |  |  | [NAME]
5 | EVER MORE | EN/EVM/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/SLVR/50/EN/W | SILVER |  |  |  | UCN/EM/HE/EVM/50/EN/W |  |  |  | CON/GF/51120/AMOR/CACHAREL/W |  |  |  | Quintessence/ Product is Already on order in Triangle-More & More
6 | ICE COOL | EN/ICL/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/LTBL/50/EN/W | TRANS BLUE |  |  |  | UCN/EM/HE/ICL/50/EN/W |  |  |  | CON/AR/DEEPRIVER/W |  |  |  | Argeville/Already on Order in Triangle-Cool Of Women
7 | ALTADORE frost | EN/ALT/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/GOLD/50/EN/W | GOLD |  |  |  | UCN/EM/HE/ALT/50/EN/W |  |  |  | CON/VM/JASL/JDOR/DIOR/W |  |  |  | V Mane Fils/ Already on Order in Dream-Splendore
8 | LOVE FOR | EN/LVF/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/MGTA/50/EN/W | MAJENTA |  |  |  | UCN/EM/HE/LVF/50/EN/W |  |  |  | CON/GF/51123/KNZAMR/KENZO/W |  |  |  | Quintessence
9 | TAKE [NAME] | EN/TKP/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/PINK/50/EN/W | PINK |  |  |  | UCN/EM/HE/TKP/50/EN/W |  |  |  | CON/AR/PNKF/TCHPNK/LCSTE/W |  |  |  | [NAME]
10 | NINEL | EN/NIN/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/WHIT/50/EN/W | WHITE |  |  |  | UCN/EM/HE/NIN/50/EN/W |  |  |  | CON/GF/51232/NINA/NINRICI/W |  |  |  | Quintessence/ Product is Already on order in Triangle-Nave
11 | DELISH | EN/DEL/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/WHIT/50/EN/W | WHITE |  |  |  | UCN/EM/HE/DEL/50/EN/W |  |  |  | CON/ES/BOLC/DLECS/DKNY/W |  |  |  | Essence
12 | ONE 2 ON ICE | EN/OOI/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/ROSE/50/EN/W | ROSE |  |  |  | UCN/EM/HE/OOI/50/EN/W |  |  |  | CON/AR/BNQS/212OICE/C.HRRA/W |  |  |  | Argeville/Already on Order in Dream-One by One
13 | LIFE & LOVE frost | EN/LIF/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/ORNG/50/EN/W | ORANGE |  |  |  | UCN/EM/HE/LIF/50/EN/W |  |  |  | CON/AR/GRCS/ILOV/MSCHNO/W |  |  |  | [NAME]
14 | ECLIPSE DU TEAMPS | EN/EDT/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/TRPP/50/EN/W | TRANS PURPLE |  |  |  | UCN/EM/HE/EDT/50/EN/W |  |  |  | CON/AR/ETNC/ECLAT/LANVIN/W |  |  |  | Quintessence/ Product is Already on order in Triangle-Nave
15 | WHITE CLOUDS frost | EN/WTC/W/50/EDT |  |  |  |  |  |  | CAP/BH/HE/LTBL/50/EN/W | TRANS BLUE |  |  |  | UCN/EM/HE/WTC/50/EN/W |  |  |  | CON/AR/COLO/LICL/MSCHNO/W |  |  |  | [NAME]
 | Total
 |  | BOT/PR/HE/CL/50/EN/W |  |  | PLAIN
 |  | BOT/PR/HE/FR/50/EN/W |  |  | FROSTED
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/DEC/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/BPR/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/E03/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ECP/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/EVM/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ICL/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ALT/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/LVF/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/TKP/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/NIN/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/DEL/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/OOI/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/LIF/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/EDT/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/WTC/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/DEC/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/BPR/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/E03/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/ECP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/EVM/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/ICL/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/ALT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/LVF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/TKP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/NIN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/DEL/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/OOI/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/LIF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/EDT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/HE/WTC/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/DEC/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/BPR/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/E03/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ECP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/EVM/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ICL/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/ALT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/LVF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/TKP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/NIN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/DEL/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/OOI/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/LIF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/EDT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/HE/WTC/50/EN/W/FMF