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

ENTITY - 50 ML - ADMIRE -
 |  |  | 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 | NANCI | EN/NAN/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/SLVR/50/EN/W | SILVER |  |  |  | UCN/EM/AD/NAN/50/EN/W |  |  |  | CON/GF/51232/NINA/NINRICI/W |  |  |  | Quintessence/ Product is alredy on order in Triangle-Nave
2 | SHINE SO BRIGHT | EN/SSB/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/PINK/50/EN/W | PINK |  |  |  | UCN/EM/AD/SSB/50/EN/W |  |  |  | CON/VM/BRTG/BRTCRYSTL/VRSCE/W |  |  |  | V Mane Fils
3 | [NAME] | EN/DLT/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/PUPL/50/EN/W | PURPLE |  |  |  | UCN/EM/AD/DLT/50/EN/W |  |  |  | CON/SC/DLCT/DLECS/DKNY/W |  |  |  | Scents
4 | MY PASSION | EN/MYP/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/BLCK/50/EN/W | BLACK |  |  |  | UCN/EM/AD/MYP/50/EN/W |  |  |  | CON/AR/MNDR/MDNPOISN/DIOR/W |  |  |  | [NAME]
5 | [NAME] | EN/SUB/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/SLVR/50/EN/W | SILVER |  |  |  | UCN/EM/AD/SUB/50/EN/W |  |  |  | CON/AF/Z21923/PROMSE/CACHAREL/W |  |  |  | [NAME]
6 | REAL LIFE | EN/RLF/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/TUBL/50/EN/W | TURQUISE BLUE |  |  |  | UCN/EM/AD/RLF/50/EN/W |  |  |  | CON/AF/14355/RLPHL/RLPHL/W |  |  |  | Argeville / Already on Order in Dream-Real Story
7 | THE FUN | EN/TFN/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/GOLD/50/EN/W | GOLD |  |  |  | UCN/EM/AD/TFN/50/EN/W |  |  |  | CON/AR/EXCP/D&G1/D&G/W |  |  |  | [NAME]
8 | LOVING MORE | EN/LVM/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/MGTA/50/EN/W | MAJENTA |  |  |  | UCN/EM/AD/LVM/50/EN/W |  |  |  | CON/GF/51123/KNZAMR/KENZO/W |  |  |  | Quintessence/ Product is alredy on order in Triangle-Nave
9 | ALWAYS SHINE | EN/ALW/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/WHIT/50/EN/W | WHITE |  |  |  | UCN/EM/AD/ALW/50/EN/W |  |  |  | CON/AR/VESH/DIORADSH/DIOR/W |  |  |  | Argeville / Already on Order in Dream-Just Addiction
10 | BLUE BELLS FROST | EN/BLB/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/SBLU/50/EN/W | SKY BLUE |  |  |  | UCN/EM/AD/BLB/50/EN/W |  |  |  | CON/AR/15112C/LTBLUE/D&G/W |  |  |  | Argeville / Already on Order in Triangle-Bright blue
11 | LEAF IN RED | EN/LFR/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/RED/50/EN/W | RED |  |  |  | UCN/EM/AD/LFR/50/EN/W |  |  |  | CON/AR/ANDR/INRED/ARMNBSI/W |  |  |  | Argeville / Already on Order in Dream-Red & White
12 | [NAME] | EN/LBZ/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/WHIT/50/EN/W | WHITE |  |  |  | UCN/EM/AD/LBZ/50/EN/W |  |  |  | CON/GF/29119/LPKNZO/KENZO/W |  |  |  | Grasse French / Already on Order in Lom-Keen
13 | HAPPY WOMEN | EN/HAP/W/50/EDT |  |  |  |  |  |  | CAP/BH/AD/ORNG/50/EN/W | ORANGE |  |  |  | UCN/EM/AD/HAP/50/EN/W |  |  |  | CON/VM/FLCA/HAPY/CLINQ/W |  |  |  | V Mane Fils
 | Total
 |  | BOT/PR/AD/CL/50/EN/W |  |  | CLEAR
 |  | BOT/PR/AD/FR/50/EN/W |  |  | FROSTED
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/NAN/50/EN/W |  |  |  | CON/ES/BIRM/BRTCRYSTL/VRSCE/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/SSB/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/DLT/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/MYP/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/SUB/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/RLF/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/TFN/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LVM/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/ALW/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/BLB/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LFR/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LBZ/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/HAP/50/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/NAN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/SSB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/DLT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/MYP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/SUB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/RLF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/TFN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/LVM/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/ALW/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/BLB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/LFR/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/LBZ/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/AD/HAP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/NAN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/SSB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/DLT/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/MYP/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/SUB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/RLF/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/TFN/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LVM/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/ALW/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/BLB/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LFR/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/LBZ/50/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/AD/HAP/50/EN/W/FMF