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

DREAM COLLECTION 100 ML (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 | BLACK CAP | DR/BLC/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/M | BLACK |  |  |  | UCN/EM/DC/BLC/100/DC/M |  |  |  | CON/AF/22147/DRKNR/GYLROCH/M |  |  |  | Azur / Already on Order in Sogo-Black Belt
2 | FLY HIGH | DR/FLH/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BRED/100/DC/M | BROWN (BROWN RED GLOSSY) |  |  |  | UCN/EM/DC/FLH/100/DC/M |  |  |  | CON/AF/14719/FHRENHT/DIOR/M |  |  |  | Azur / Already on Order in Sogo-Fire Gate
3 | AQUILION (Fost) | DR/AQU/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/M | SILVER |  |  |  | UCN/EM/DC/AQU/100/DC/M |  |  |  | CON/VM/ALEX/AQDGIO/ARMN/M |  |  |  | V Mane Fils / Already on Order in Sleek-Aqua Zone
4 | COOL DUDE | DR/COD/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/M | BLACK |  |  |  | UCN/EM/DC/COD/100/DC/M |  |  |  | CON/AR/FRSM/COLWTR/DVIDF/M |  |  |  | Argeville / Already on Order in Sleek-Cool Of Men
5 | EGO  (Frost) | DR/EGO/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/M | SILVER |  |  |  | UCN/EM/DC/EGO/100/DC/M |  |  |  | CON/AR/POWR/PLTEGO/CHANEL/M |  |  |  | Argeville / Already on Order in Sleek-Paladium
6 | ENDORSE | DR/END/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/M | SILVER |  |  |  | UCN/EM/DC/END/100/DC/M |  |  |  | CON/GR/BLCH/BOS98/HBOSS/M |  |  |  | Grasse / Alreaduy on Order in Sogo-Across
7 | TREAT | DR/TRT/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/M | BLACK |  |  |  | UCN/EM/DC/TRT/100/DC/M |  |  | 0 | CON/ES/TONG/THEBT/BRBERY/M |  |  |  | Essence
8 | MILLIONAIRE | DR/MIL/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/GOLD/100/DC/M | GOLD |  |  |  | UCN/EM/DC/MIL/100/DC/M |  |  |  | CON/GR/30/6330/1MIL/PRABN/M |  |  |  | Grasse
9 | JUST HOMME SPORT | DR/JSH/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/M | Black |  |  |  | UCN/EM/DC/JSH/100/DC/M |  |  |  | CON/ES/DESM/DIORHMSP/DIOR/M |  |  |  | Essence / Already on Order in Sogo-Daily Home Sport
10 | ONE BY ONE ICE JUST ICE MEN | DR/OBO/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/M | Silver |  |  |  | UCN/EM/DC/OBO/100/DC/M |  |  |  | CON/AR/BNQS/212OICE/C.HRRA/M |  |  |  | [NAME]
11 | [NAME] JUST ONE | DR/DDG/M/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BRMT/100/DC/M | Brown m |  |  |  | UCN/EM/DC/DDG/100/DC/M |  |  |  | CON/QU/69650/D&G1/D&G/M |  |  |  | Quintessence / Already On Order in Sogo-Dolecetto
 | Total
 |  | BOT/HZ/DC/FR/100/DC/M |  |  | FROST
 |  | BOT/HZ/DC/CL/100/DC/M/NEW |  |  | PLAIN
DREAM COLLECTION 100 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 | REAL STORY | DR/RST/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/LTQB/100/DC/W | T.BLUE |  |  |  | UCN/EM/DC/RST/100/DC/W |  |  |  | CON/AR/LAUR/RLPHL/RLPHL/W |  |  |  | Argeville / Already on Order in Triangle-Reality
2 | SOME MORE | DR/SOM/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/W | SILVER |  |  |  | UCN/EM/DC/SOM/100/DC/W |  |  |  | CON/AR/SVTF/AMOR/CACHARELW |  |  |  | [NAME]
3 | [NAME] | DR/KEN/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/W | SILVER |  |  |  | UCN/EM/DC/KEN/100/DC/W |  |  |  | CON/AR/ZENK/KNZAMR/KENZO/W |  |  |  | [NAME]
4 | JINGLE | DR/JIN/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/DABL/100/DC/W | L.BLUE |  |  |  | UCN/EM/DC/JIN/100/DC/W |  |  |  | CON/AR/VIRG/ANGL/TMUGLR/W |  |  |  | [NAME]
5 | CHAT (Frost) | DR/CHT/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/W | SILVER |  |  |  | UCN/EM/DC/CHT/100/DC/W |  |  |  | CON/SC/JANE/NO5/CHANEL/W |  |  |  | Grasse French / Already on [NAME] in Triangle-5 Number
6 | SENSIBLE ME | DR/SEN/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/W | BLACK |  |  |  | UCN/EM/DC/SEN/100/DC/W |  |  |  | CON/AR/SNGL/INCME/ESCADA/W |  |  |  | [NAME]
7 | SPLENDORE (Frost) | DR/SPL/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/GOLD/100/DC/W | GOLD |  |  |  | UCN/EM/DC/SPL/100/DC/W |  |  |  | CON/VM/JASL/JDOR/DIOR/W |  |  |  | MANE FILS
8 | HER PASSION | DR/HRP/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/BLCK/100/DC/W | BLACK |  |  |  | UCN/EM/DC/HRP/100/DC/W |  |  |  | CON/AR/DIAB/HYPPOISN/DIOR/W |  |  |  | [NAME]
9 | [NAME] JUST ONE | DR/DGR/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/LTBR/100/DC/W | Brown S |  |  |  | UCN/EM/DC/DGR/100/DC/W |  |  |  | CON/AR/ROEX/D&GRSTHE1/D&G/W |  |  |  | Argeville / Already on Order in Aspire-The Rose
10 | ONE BY ONE ICE JUST ICE   WOMEN | DR/OBO/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/W | SILVER |  |  |  | UCN/EM/DC/OBO/100/DC/W |  |  |  | CON/AR/BNQS/212OICE/C.HRRA/W |  |  |  | [NAME]
11 | RED AND WHITE | DR/RAW/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/SLVR/100/DC/W | SILVER |  |  |  | UCN/EM/DC/RAW/100/DC/W |  |  |  | CON/AR/ANDR/INRED/ARMNBSI/W |  |  |  | [NAME]
12 | JUST ADDICTION SHINE | DR/JAD/W/100/EDT |  |  |  |  |  |  | CAP/HZ/DC/LTPI/100/DC/W | Pink S |  |  |  | UCN/EM/DC/JAD/100/DC/W |  |  |  | CON/AR/VESH/DIORADSH/DIOR/W |  |  |  | same with 30ml Always [NAME]
 | Total
 |  | BOT/HZ/DC/FR/100/DC/W |  |  | FROST
 |  | BOT/HZ/DC/CL/100/DC/W |  |  | PLAIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/BLC/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/FLH/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/AQU/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/COD/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/EGO/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/END/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/TRT/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/MIL/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JSH/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/OBO/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/DDG/100/DC/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/RST/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SOM/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/KEN/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JIN/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/CHT/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SEN/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SPL/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/HRP/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/DGR/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/OBO/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/RAW/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JAD/100/DC/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/BLC/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/FLH/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/AQU/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/COD/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/EGO/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/END/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/TRT/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/MIL/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/JSH/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/OBO/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/DDG/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/RST/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/SOM/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/KEN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/JIN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/CHT/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/SEN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/SPL/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/HRP/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/DGR/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/OBO/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/RAW/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DC/JAD/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/BLC/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/FLH/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/AQU/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/COD/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/EGO/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/END/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/TRT/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/MIL/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JSH/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/OBO/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/DDG/100/DC/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/RST/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SOM/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/KEN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JIN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/CHT/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SEN/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/SPL/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/HRP/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/DGR/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/OBO/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/RAW/100/DC/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DC/JAD/100/DC/W/FMF