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

[NAME] (MEN)
 |  | FINISH PRODUCT |  |  | BOTTLE |  |  |  | CAPS |  |  |  |  | UNIT CARTONS |  |  |  | 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 | SPHERE | DR/SPH/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/LTGR/100/DC/M | [NAME] c |  |  |  | UCN/UT/G105/SPH/100/DC/M |  |  |  | CON/FI/1667HB16/AQPR/BVLGRI/M |  |  |  | FERMINESH
2 | DOUBLE | DR/DBL/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/BLCK/100/DC/M | BLACK |  |  |  | UCN/UT/G105/DOU/100/DC/M |  |  |  | CON/AR/TAND/38137C/AZZARO/M |  |  |  | FERMINESH
3 | FIRE SIGHT | DR/FST/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/BLCK/100/DC/M | BLACK |  |  |  | UCN/UT/G105/FRS/100/DC/M |  |  |  | CON/FI/2020AX12/AQUA/CRSTDR/M |  |  |  | FERMINESH
4 | MANLY MAN | DR/MLY/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/MTSLVR/100/DC/M | SILVER MAT |  |  |  | UCN/UT/G105/MAN/100/DC/M |  |  |  | CON/FI/IVORY/1850LA10/LEMAL/GAULT/M |  |  |  | FERMINESH
5 | RANGE | DR/RAG/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/BLCK/100/DC/M | BLACK |  |  |  | UCN/UT/G105/RAN/100/DC/M |  |  |  | CON/FI/193987/BOOR/HUGO/M |  |  |  | FERMINESH
6 | AGENT | DR/AGT/M/100/EDT |  |  |  |  |  | CAP/HZ/G105/SHSLVR/100/DC/M | SILVER SHINY |  |  |  | UCN/UT/G105/AGN/100/DC/M |  |  |  | CON/FI/2051X11/SVGE/DIOR/M |  |  |  | FERMINESH
 | Total
 |  | BOT/HZ/G105/CLR/100/DC/M
[NAME] ML (WOMEN)
 |  | FINISH PRODUCT |  |  | BOTTLE |  |  |  | CAPS |  |  |  |  | UNIT CARTONS |  |  |  | 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 | NICE CHANCE | DR/NCH/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/SLVR/100/DC/W | SILVER MAT |  |  |  | UCN/UT/G141/NIC/100/DC/W |  |  |  | CON/FI/193970D/ANAIS/CARL/W |  |  |  | FERMINESH
2 | RED [NAME] | DR/RKT/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/BLCK/100/DC/W | BLACK |  |  |  | UCN/UT/G141/RED/100/DC/W |  |  |  | CON/FI/2050H20/RICCI/NINA/W |  |  |  | FERMINESH
3 | EXPOSE | DR/EXP/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/SLVR/100/DC/W | SILVER MAT |  |  |  | UCN/UT/G141/EXP/100/DC/W |  |  |  | CON/FI/2051W15/GLTR/JPGLTR/W |  |  |  | FERMINESH
4 | POEM | DR/POM/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/RED/100/DC/W | RED 202 C |  |  |  | UCN/UT/G141/POE/100/DC/W |  |  |  | CON/FI/2051B12/OPIUM/YSLRNT/W |  |  |  | FERMINESH
5 | IDLE ROSE | DR/IDL/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/GOLD/100/DC/W | GOLD |  |  |  | UCN/UT/G141/IDL/100/DC/W |  |  |  | CON/FI/248444/IDYLDT/GRLN/W |  |  |  | FERMINESH
6 | DUET | DR/DUT/W/100/EDT |  |  |  |  |  | CAP/HZ/G141/GOLD/100/DC/W | GOLD |  |  |  | UCN/UT/G141/DUE/100/DC/W |  |  |  | CON/FI/1842W10/AZZRODO/W |  |  |  | FERMINESH
 | Total
 |  | BOT/HZ/G141/CLR/100/DC/W