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

ENTITY - 100 ML - SLEEK
 |  |  | FINISH PRODUCT |  |  | BOTTLE |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | FG STOCK | To Produce |  | STOCK | ON ORDER | Stock after Production & On Order |  | CAP 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 | BON AQUA | EN/BON/M/100/EDT |  |  |  |  |  |  |  | SILVER |  |  |  | UCN/EM/SL/BON/100/EN/M |  |  |  | CON/GF/51266/AQUA/BVLGRI/M |  |  |  | Quintessence
2 | [NAME] | EN/ACT/M/100/EDT |  |  |  |  |  |  |  | SILVER |  |  |  | UCN/EM/SL/ACT/100/EN/M |  |  |  | CON/PB/ARSP/ALURSP/CHANEL/M |  |  |  | Perfume Boulevard
3 | AQUA ZONE FROST | EN/AQU/M/100/EDT |  |  |  |  |  |  |  | SILVER |  |  |  | UCN/EM/SL/AQU/100/EN/M |  |  |  | CON/VM/ALEX/AQDGIO/ARMN/M |  |  |  | V Mane Fils
4 | CAREER MAN | EN/CKM/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SL/CKM/100/EN/M |  |  |  | CON/VM/LUMO/MAN/CK/M |  |  |  | V Mane Fils
5 | EXCEL | EN/EXL/M/100/EDT |  |  |  |  |  |  | CAP/CH/SL/SLVR/100/EN/M | SILVER |  |  |  | UCN/EM/SL/EXL/100/EN/M |  |  |  | CON/AF/22145/LHOM/YSL/M |  |  |  | [NAME]
6 | COOL OFF MEN | EN/COL/M/100/EDT |  |  |  |  |  |  | CAP/CH/SL/BLCK/100/EN/M | BLACK |  |  |  | UCN/EM/SL/COL/100/EN/M |  |  |  | CON/AR/FRSM/COLWTR/DVIDF/M |  |  |  | [NAME]
7 | MOVE ENERGY | EN/MOV/M/100/EDT |  |  |  |  |  |  | CAP/CH/SL/DRGR/100/EN/M | GREEN |  |  |  | UCN/EM/SL/MOV/100/EN/M |  |  |  | CON/VM/HPEN/HGHENRGY/DIOR/M |  |  |  | V Mane Fils
8 | BASE CODE | EN/BAS/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SL/BAS/100/EN/M |  |  |  | CON/AR/CPHR/BLKCOD/GOARM/M |  |  |  | [NAME]
9 | PALADIUM ELITE | EN/PAL/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SL/PAL/100/EN/M |  |  |  | CON/AR/POWR/PLTEGO/CHANEL/M |  |  |  | [NAME]
10 | FIRE GATE ABSOLUTION | EN/FIR/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SL/FIR/100/EN/M |  |  |  | CON/VM/FOAB/FRNHTABS/DIOR/M |  |  |  | V Mane Fils
 | Total
 |  | BOT/PR/SL/FR/100/EN/M |  | Frosted
 |  | BOT/PR/SL/CL/100/EN/M |  | Plain
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/BON/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/ACT/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/AQU/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/CKM/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/EXL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/COL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/MOV/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/BAS/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/PAL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/FIR/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/BON/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/ACT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/AQU/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/CKM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/EXL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/COL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/MOV/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/BAS/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/PAL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SL/FIR/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/BON/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/ACT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/AQU/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/CKM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/EXL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/COL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/MOV/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/BAS/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SL/PAL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SL/FIR/100/EN/M/FMF