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

ENTITY - 50ml - LOM
 |  | Finished Goods |  |  | BOTTLE |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | STOCK | To Produce | STOCK | ON ORDER | Stock after Production & On Order |  | CAPS 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 | KEEN | EN/KEE/W/50/EDT |  |  |  |  |  | CAP/BH/LO/NABL/50/EN/W | NAVY BLUE |  |  |  | UCN/EM/LO/KEE/50/EN/W |  |  |  | CON/GF/29119/LPKNZO/KENZO/W |  |  |  | Quintessence
2 | FLORAL | EN/FLR/W/50/EDT |  |  |  |  |  | CAP/BH/LO/RED/50/EN/W | RED |  |  |  | UCN/EM/LO/FLR/50/EN/W |  |  |  | CON/PF/9/0135/2/FLWR/KENZO/W |  |  |  | Perfumania
3 | ACROSS | EN/ACR/W/50/EDT |  |  |  |  |  | CAP/BH/LO/PECH/50/EN/W | PEACH |  |  |  | UCN/EM/LO/ACR/50/EN/W |  |  |  | CON/VM/FMNA/NWBOSSFM/HUGO/W |  |  |  | V Mane Fils
4 | 18TH CEREMONY - FRO | EN/18T/W/50/EDT |  |  |  |  |  | CAP/BH/LO/BIGE/50/EN/W | BEIGE |  |  |  | UCN/EM/LO/18T/50/EN/W |  |  |  | CON/AF/11266/1881CRUT/CRUT/W |  |  |  | [NAME]
5 | PROPOSE | EN/PRP/W/50/EDT |  |  |  |  |  | CAP/BH/LO/BLUE/50/EN/W | BLUE |  |  |  | UCN/EM/LO/PRP/50/EN/W |  |  |  | CON/GR/30/5608/HYPN/LNCOM/W |  |  |  | Grasse French
6 | EXCESS  - FRO | EN/EXC/W/50/EDT |  |  |  |  |  | CAP/BH/LO/GOLD/50/EN/W | GOLD |  |  |  | UCN/EM/LO/EXC/50/EN/W |  |  |  | CON/VM/XANA/HUGOXX/HUGO/W |  |  |  | V Mane Fils
7 | MUSICAL | EN/MUS/W/50/EDT |  |  |  |  |  | CAP/BH/LO/SLVR/50/EN/W | SILVER |  |  |  | UCN/EM/LO/MUS/50/EN/W |  |  |  | CON/SC/EVRL/MCLFVR/LNCOM/W |  |  |  | Scents
8 | GREEN TEEN | EN/GRT/W/50/EDT |  |  |  |  |  | CAP/BH/LO/GREN/50/EN/W | GREEN |  |  |  | UCN/EM/LO/GRT/50/EN/W |  |  |  | CON/GR/29/4280/GT/EARDEN/W
9 | GLAMORIZE | EN/GLM/W/50/EDT |  |  |  |  |  | CAP/BH/LO/RDTR/50/EN/W | TRANS RED |  |  |  | UCN/EM/LO/GLM/50/EN/W |  |  |  | CON/AR/GLEM/GLMOR/MSCHNO/W |  |  |  | [NAME]
10 | PREMIUM LUX | EN/PLX/W/50/EDT |  |  |  |  |  | CAP/BH/LO/WHIT/50/EN/W | WHITE |  |  |  | UCN/EM/LO/PLX/50/EN/W |  |  |  | CON/AF/24393/PRMJOR/NINRICI/W |  |  |  | [NAME]
11 | FLORALE | EN/FBE/W/50/EDT |  |  |  |  |  | CAP/BH/LO/BLCK/50/EN/W | BLACK |  |  |  | UCN/EM/LO/FBE/50/EN/W |  |  |  | CON/ES/FARA/GUCIFLR/GUCI/W |  |  |  | Essence/ Already on Order in Aspire-Florence
12 | DOLCETTO ROSE THE ONE | EN/DRO/W/50/EDT |  |  |  |  |  | CAP/BH/LO/BRWN/50/EN/W | L . BROWN |  |  |  | UCN/EM/LO/DLT/50/EN/W |  |  |  | CON/AR/ROEX/D&GRSTHE1/D&G/W |  |  |  | Argeville/ Already on Order in Dream-Red & White
13 | CHANCY WOMEN | EN/CHW/W/50/EDT |  |  |  |  |  | CAP/BH/LO/TRWH/50/EN/W | NATURAL |  |  |  | UCN/EM/LO/CHW/50/EN/W |  |  |  | CON/VM/HBRK/CHNCE/CHANEL/W |  |  |  | V Mane Fils
 | Total
 |  | BOT/PR/LO/FR/50/EN/W |  | FROSTED
 |  | BOT/PR/LO/CL/50/EN/W |  | PLAIN
 |  |  |  | Customer | Quantity
 | KEEN | EN/KEE/W/50/EDT |  | Perfumes Standard | 288
 | FLORAL | EN/FLR/W/50/EDT |  | No Order
 | ACROSS | EN/ACR/W/50/EDT |  | Perfumes Standard | 144
 | 18TH CEREMONY - FRO | EN/18T/W/50/EDT |  | Perfumes Standard | 288
 | PROPOSE | EN/PRP/W/50/EDT |  | No Order
 | EXCESS  - FRO | EN/EXC/W/50/EDT |  | Perfumes Standard | 432
 | MUSICAL | EN/MUS/W/50/EDT |  | Silex | 850
 | GREEN TEEN | EN/GRT/W/50/EDT |  | Perfumes Standard | 1008
 | GLAMORIZE | EN/GLM/W/50/EDT |  | No Order
 | PREMIUM LUX | EN/PLX/W/50/EDT |  | No Order
 | FLORALE | EN/FBE/W/50/EDT |  | No Order
 | DOLCETTO ROSE THE ONE | EN/DRO/W/50/EDT |  | No Order
 | CHANCY WOMEN | EN/CHW/W/50/EDT |  | Perfumes Standard | 144