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

SR.NO | ITEM CODE | [NAME] |  |  | TOTAL  ORDERED | STOCK | BALANCE | STOCK | BALANCE
 |  | ENTITY 30 ML |  |  |  |  | * |  |  |  | Column1 | Column3
1 | EN/ALW/W/30/EDT | [NAME] SHINE Women 30ml E |  |  | 0 |  |  |  |  |  | Product | Total Ordered
2 | EN/CLT/W/30/EDT | [NAME] Women 30ml EDT |  |  | 0 |  |  |  |  |  | Entity 30ml
3 | EN/DEL/W/30/EDT | ENTITY DELISH Women 30ml EDT |  |  | 0 |  |  |  |  |  | Entity 50ml
4 | EN/EDT/W/30/EDT | ENTITY ECLIPSE DU TEMPS Women 30 |  |  | 0 |  |  |  |  |  | Entity 100ml
5 | EN/ENC/W/30/EDT | ENTITY ENCHANT SHINE Women 30ml |  |  | 0 |  |  |  |  |  | Dream
6 | EN/FUJ/W/30/EDT | ENTITY FUJI Women 30ml |  |  | 0 |  |  |  |  |  | Odean
7 | EN/GRT/W/30/EDT | ENTITY GREEN TEEN Women 30ml EDT |  |  | 0 |  |  |  |  |  | Roi
8 | EN/HYP/W/30/EDT | ENTITY HYPNOTISME Women 30ml EDT |  |  | 0 |  |  |  |  |  | O/L & Lutece
9 | EN/LBZ/W/30/EDT | ENTITY LIS BLANC ZONE Women 30ml |  |  | 0
10 | EN/LFR/W/30/EDT | ENTITY LEAF IN RED Women 30ml ED |  |  | 0
11 | EN/LIF/W/30/EDT | ENTITY LIFE AND LOVE Women 30ml |  |  | 0
12 | EN/MAG/W/30/EDT | ENTITY MAGIC NOYAU Women 30ml ED |  |  | 0
13 | EN/SSB/W/30/EDT | ENTITY SHINE SO BRIGHT Women 30m |  |  | 0
14 | EN/WEK/W/30/EDT | ENTITY WEEK IN Women 30ml EDT |  |  | 0
15 | EN/WTC/W/30/EDT | [NAME] 30ml E |  |  | 0
 |  |  |  |  | 0
 |  | ENTITY 50 ML |  |  |  |  | *
1 | EN/18T/W/50/EDT | ENTITY 18 TH CEREMONY Women 50ml |  |  | 288
2 | EN/ACR/W/50/EDT | ENTITY ACROSS Women 50ml EDT |  |  | 144
3 | EN/ALT/W/50/EDT | ENTITY ALTADORE Women 50ml EDT |  |  | 0
4 | EN/ALW/W/50/EDT | [NAME] SHINE Women 50ml E |  |  | 432
5 | EN/BPR/W/50/EDT | ENTITY BE PRECISE Women 50ml EDT |  |  | 0
6 | EN/BLB/W/50/EDT | ENTITY BLUE BELLS Women 50ml EDT |  |  | 1008
7 | EN/CHW/W/50/EDT | ENTITY CHANCY WOMEN Women 50ml E |  |  | 144
8 | EN/DEC/W/50/EDT | ENTITY DECODEL Women 50ml EDT |  |  | 864
9 | EN/DLT/W/50/EDT | ENTITY DELIGHT Women 50ml EDT |  |  | 576
10 | EN/DEL/W/50/EDT | ENTITY DELISH Women 50ml EDT |  |  | 1008
11 | EN/DRO/W/50/EDT | ENTITY DOLCETO ROSE THE ONE Women |  |  | 0
12 | EN/E03/W/50/EDT | ENTITY E 203 Women 50ml EDT |  |  | 720
13 | EN/ECP/W/50/EDT | ENTITY ECLIPS Women 50ml EDT |  |  | 864
14 | EN/EDT/W/50/EDT | ENTITY ECLIPSE DU TEMPS Women 50 |  |  | 1296
15 | EN/EVM/W/50/EDT | ENTITY EVER MORE Women 50ml EDT |  |  | 1426
16 | EN/EXC/W/50/EDT | ENTITY EXCESS Women 50ml EDT |  |  | 432
17 | EN/FLR/W/50/EDT | ENTITY FLORAL Women 50ml EDT |  |  | 0
18 | EN/FBE/W/50/EDT | [NAME] BY ENTITY Women 50 ml |  |  | 0
19 | EN/GLM/W/50/EDT | ENTITY GLAMORIZE Women 50ml EDT |  |  | 0
20 | EN/GRT/W/50/EDT | ENTITY GREEN TEEN Women 50ml EDT |  |  | 1008
21 | EN/HAP/W/50/EDT | ENTITY HAPPY WOMEN Women 50ml ED |  |  | 144
22 | EN/ICL/W/50/EDT | ENTITY ICE COOL Women 50ml EDT |  |  | 1296
23 | EN/KEE/W/50/EDT | ENTITY KEEN Women 50ml EDT |  |  | 288
24 | EN/LFR/W/50/EDT | ENTITY LEAF IN RED Women 50ml ED |  |  | 864
25 | EN/LIF/W/50/EDT | ENTITY LIFE AND LOVE Women 50ml |  |  | 720
26 | EN/LBZ/W/50/EDT | ENTITY LIS BLANC ZONE Women 50ml |  |  | 864
27 | EN/LVF/W/50/EDT | ENTITY LOVE FOR Women 50ml EDT |  |  | 288
28 | EN/LVM/W/50/EDT | ENTITY LOVING MORE Women 50ml ED |  |  | 288
29 | EN/MUS/W/50/EDT | ENTITY MUSICAL Women 50ml EDT |  |  | 850
30 | EN/MYP/W/50/EDT | ENTITY MY PASSION Women 50ml EDT |  |  | 288
31 | EN/NAN/W/50/EDT | ENTITY NANCI Women 50ml EDT |  |  | 1008
32 | EN/NIN/W/50/EDT | ENTITY NINEL Women 50ml EDT |  |  | 0
33 | EN/OOI/W/50/EDT | ENTITY ONE2 ON ICE Women 50ml ED |  |  | 288
34 | EN/PLX/W/50/EDT | ENTITY PREMIUM LUX Women 50ml ED |  |  | 0
35 | EN/PRP/W/50/EDT | ENTITY PROPOSE Women 50ml EDT |  |  | 0
36 | EN/RLF/W/50/EDT | ENTITY REAL LIFE Women 50ml EDT |  |  | 0
37 | EN/SSB/W/50/EDT | ENTITY SHINE SO BRIGHT Women 50m |  |  | 288
38 | EN/SUB/W/50/EDT | [NAME] Women 50ml EDT |  |  | 720
39 | EN/TKP/W/50/EDT | ENTITY TAKE PINK Women 50ml EDT |  |  | 576
40 | EN/TFN/W/50/EDT | ENTITY THE FUN Women 50ml EDT |  |  | 288
41 | EN/WTC/W/50/EDT | [NAME] Women 50ml E |  |  | 0
 |  |  |  |  | 19268
 |  | ENTITY 100 ML |  |  |  |  | *
1 | EN/ACR/M/100/EDT | ENTITY ACROSS Men 100ml EDT |  |  | 11364
2 | EN/ACT/M/100/EDT | ENTITY ACTION SPORTS Men 100ml EDT |  |  | 3576
3 | EN/AZN/M/100/EDT | [NAME] 100ml EDT |  |  | 5460
4 | EN/AQU/M/100/EDT | ENTITY AQUA ZONE Men 100ml EDT |  |  | 2280
5 | EN/BAS/M/100/EDT | ENTITY BASE CODE Men 100ml EDT |  |  | 2124
6 | EN/BAM/M/100/EDT | ENTITY BIG AMBITION Men 100ml EDT |  |  | 6084
7 | EN/BLB/M/100/EDT | ENTITY BLACK BELT Men 100ml EDT |  |  | 13096
8 | EN/BON/M/100/EDT | ENTITY BON AQUA Men 100ml EDT |  |  | 4764
9 | EN/CKM/M/100/EDT | ENTITY CAREER MAN Men 100ml EDT |  |  | 5120
10 | EN/COL/M/100/EDT | ENTITY COOL OFF MEN Men 100ml EDT |  |  | 3936
11 | EN/DHS/M/100/EDT | [NAME] HOMME SPORT Men 100 |  |  | 1320
12 | EN/DFN/M/100/EDT | [NAME] 100ml EDT |  |  | 1680
13 | EN/DVG/M/100/EDT | ENTITY DIVING SUIT Men 100ml EDT |  |  | 4200
14 | EN/DLT/M/100/EDT | ENTITY DOLCETTO Men 100ml EDT |  |  | 9792
15 | EN/DTO/M/100/EDT | ENTITY DOLCETTO THE ONE Men 100m |  |  | 9886
16 | EN/EXL/M/100/EDT | ENTITY EXCEL Men 100ml EDT |  |  | 2040
17 | EN/FIR/M/100/EDT | ENTITY FIRE GATE ABSOLUTION Men 100 |  |  | 3048
18 | EN/FGT/M/100/EDT | ENTITY FIRE GATE Men 100ml EDT |  |  | 4164
19 | EN/GBL/M/100/EDT | ENTITY GIVEN BLUE LEVEL Men 100m |  |  | 10024
20 | EN/GDG/M/100/EDT | ENTITY GOOD GUY Men 100ml EDT |  |  | 1608
21 | EN/MOV/M/100/EDT | ENTITY MOVE ENERGY Men 100ml EDT |  |  | 3636
22 | EN/PAL/M/100/EDT | ENTITY PALADIUM ELITE Men 100ml |  |  | 1584
 | EN/9HD/M/100/EDT | ENTITY COLLECTIONS 9HUNDRED MEN 100ML EDT |  |  | 1704
 | EN/AEF/M/100/EDT | ENTITY COLLECTIONS ALTITUDE EFFECT MEN 100ML EDT |  |  | 1476
 | EN/DLB/M/100/EDT | ENTITY COLLECTIONS DEEPLY BLACK MEN 100ML EDT |  |  | 1008
 | EN/EFC/M/100/EDT | ENTITY COLLECTIONS E'FRANCKY MEN 100ML EDT |  |  | 1032
 | EN/GAL/M/100/EDT | ENTITY COLLECTIONS GALLANT MEN 100ML EDT |  |  | 1500
 | EN/JMP/M/100/EDT | ENTITY COLLECTIONS JUMP MEN 100ML EDT |  |  | 1476
 | EN/JTM/M/100/EDT | ENTITY COLLECTIONS JUST MAN MEN 100ML EDT |  |  | 1950
 | EN/MID/M/100/EDT | ENTITY COLLECTIONS MIDNIGHT MEN 100ML EDT |  |  | 1670
 | EN/OFH/M/100/EDT | ENTITY COLLECTIONS ONLY FOR HIM MEN 100ML EDT |  |  | 2066
 | EN/PRD/M/100/EDT | ENTITY  PARODY POUR HOMME MEN 100ML EDT |  |  | 648
 | EN/TSK/M/100/EDT | ENTITY COLLECTIONS TUSK MEN 100ML EDT |  |  | 8092
 | EN/WAY/M/100/EDT | ENTITY COLLECTIONS WAY MEN 100ML EDT |  |  | 1356
 | EN/BRB/W/100/EDT | ENTITY BRIGHT BLUE Women 100ml EDT |  |  | 9036
 | EN/COL/W/100/EDT | ENTITY COOL OFF W Women 100ml EDT |  |  | 2160
 | EN/MOR/W/100/EDT | ENTITY MORE & MORE Women 100ml EDT |  |  | 7522
 | EN/NAV/W/100/EDT | ENTITY NAVE Women 100ml EDT |  |  | 6168
 | EN/RTY/W/100/EDT | ENTITY REALITY Women 100ml EDT |  |  | 4152
 | EN/VIC/W/100/EDT | ENTITY VICTORIA Women 100ml EDT |  |  | 1848
 | EN/5NM/W/100/EDT | ENTITY 5 NUMBER WOMEN 100 ml EDT |  |  | 816
 | EN/CMT/W/100/EDT | [NAME] WOMAN 100 ml EDT |  |  | 8368
 | EN/FUJ/W/100/EDT | ENTITY FUJI WOMEN  100 ml.EDT |  |  | 924
 | EN/MGCW/W/100/EDT | ENTITY MAGIC WOMEN WOMEN 100ml EDT |  |  | 9118
 | EN/ROCO/W/100/EDT | ENTITY ROCOCO WOMEN 100 ml. EDT |  |  | 8388
 | EN/WEK/W/100/EDT | ENTITY WEEK IN WOMEN 100 ml EDT |  |  | 1932
 | EN/BGL/W/100/EDT | ENTITY BLACK GLAMOUR WOMEN 100 ml |  |  | 9466
 | EN/CCL/W/100/EDT | ENTITY CHERY CHERY LADY WOMEN 100ml |  |  | 1734
 | EN/FLO/W/100/EDT | ENTITY FLORENCE WOMEN 100ml EDT |  |  | 8332
 | EN/PRT/W/100/EDT | ENTITY PRETTY PRETYY WOMEN 100ml |  |  | 2310
 | EN/SPR/W/100/ED | ENTITY SAPPHIRE WOMEN 100ml. |  |  | 1248
 | EN/TRS/W/100/EDT | ENTITY THE ROSE WOMEN 100ml |  |  | 1892
 | EN/DOR/W/100/EDT | [NAME] 100ml EDT |  |  | 1896
 | EN/IDO/W/100/EDT | ENTITY I DOLLY WOMEN 100ml EDT |  |  | 1500
 | EN/ORN/W/100/EDT | ENTITY ORANGE WOMEN 100ml EDT |  |  | 1392
 | EN/VER/W/100/EDT | ENTITY VERSAILLES WOMEN 100ml EDT |  |  | 2282
 | EN/DEW/W/100/EDT | ENTITY DEW WOMEN 100ml EDT |  |  | 1824
 | EN/ABT/W/100/EDT | ENTITY ABILITY WOMEN 100ml EDT |  |  | 3264
 | EN/DBR/W/100/EDT | [NAME] 100ml EDT |  |  | 3264
 | EN/AUR/W/100/EDT | ENTITY AURA WOMEN 100ml EDT |  |  | 1824
 | EN/IMP/W/100/EDT | ENTITY IMPRESSION WOMEN 100ml EDT |  |  | 1824
 | EN/VNT/W/100/EDT | ENTITY VANITY WOMEN 100ml EDT |  |  | 3264
 |  |  |  |  | 242512
 |  | DREAM COLLECTION |  |  |  |  | *
1 | DR/AQU/M/100/EDT | DREAM AQUILON Men 100ml EDT |  |  | 2484
2 | DR/BLC/M/100/EDT | DREAM BLACK CAP Men 100ml EDT |  |  | 4314
3 | DR/COD/M/100/EDT | DREAM COOL DUDE Men 100ml EDT |  |  | 1620
4 | DR/DDG/M/100/EDT | [NAME] JUST ONE M 100 |  |  | 1548
5 | DR/EGO/M/100/EDT | [NAME] 100ml EDT |  |  | 2400
6 | DR/END/M/100/EDT | DREAM ENDORSE Men 100ml EDT |  |  | 2988
7 | DR/FLH/M/100/EDT | DREAM FLY HIGH Men 100ml EDT |  |  | 2520
8 | DR/JSH/M/100/EDT | [NAME] JUST HOMME SPORT Men 100ml |  |  | 1548
9 | DR/MIL/M/100/EDT | [NAME] 100ml EDT |  |  | 2310
10 | DR/TRT/M/100/EDT | DREAM TREAT Men 100ml EDT |  |  | 3864
11 | DR/OBO/M/100/EDT | DREAM ONE BY ONE JUST ICE Men 100ml |  |  | 1392
12 | DR/CHT/W/100/EDT | DREAM CHAT Women 100ml EDT |  |  | 1080
13 | DR/HRP/W/100/EDT | [NAME] Women 100ml EDT |  |  | 1296
14 | DR/JIN/W/100/EDT | [NAME] Women 100ml EDT |  |  | 2808
15 | DR/KEN/W/100/EDT | DREAM KENMORE Women 100ml EDT |  |  | 3240
16 | DR/RST/W/100/EDT | [NAME] 100ml EDT |  |  | 3360
17 | DR/SEN/W/100/EDT | DREAM SENSIBLE ME Women 100ml EDT |  |  | 1080
18 | DR/SOM/W/100/EDT | DREAM SOME MORE Women 100ml EDT |  |  | 1080
19 | DR/SPL/W/100/EDT | DREAM   SPLENDORE Women 100ml EDT |  |  | 1296
20 | DR/RAW/W/100/EDT | DREAM RED AND WHITE Women 100ml |  |  | 1548
21 | DR/JAD/W/100/EDT | DREAM JAST ADDICTION SHINE Women100 |  |  | 1998
22 | DR/OBO/W/100/EDT | DREAM ONE BY ONE JUST ICE Women 100ml |  |  | 1080
23 | DR/DGR/W/100/EDT | [NAME] JUST ONE W |  |  | 1626
24 | DR/DUT/W/100/EDT | DREAM COLLECTION DUET Women 100ml EDT |  |  | 5460
25 | DR/RKT/W/100/EDT | DREAM COLLECTION RED KNOT Women 100ml EDT |  |  | 5460
26 | DR/EXP/W/100/EDT | DREAM COLLECTION EXPOSE Women 100ml EDT |  |  | 5460
27 | DR/NCH/W/100/EDT | [NAME] Women 100ml EDT |  |  | 5460
28 | DR/POM/W/100/EDT | [NAME]Women 100ml EDT |  |  | 5460
29 | DR/IDL/W/100/EDT | DREAM COLLECTION IDLE  Women 100ml EDT |  |  | 5460
30 | DR/SPH/M/100/EDT | DREAM COLLECTION SPHERE  Men  100ml EDT |  |  | 5460
31 | DR/AGT/M/100/EDT | DREAM COLLECTION AGENT Men  100ml EDT |  |  | 5460
32 | DR/FSTT/M/100/EDT | [NAME]  100ml EDT |  |  | 5460
33 | DR/RAG/M/100/EDT | [NAME]  100ml EDT |  |  | 5460
34 | DR/DBL/M/100/EDT | [NAME]  100ml EDT |  |  | 5460
35 | DR/MLY/M/100/EDT | DREAM COLLECTION MANLY MAN  Men  100ml EDT |  |  | 5460
 |  |  |  |  | 114000
 |  | ODEON COLLECTION |  |  |  |  | *
1 | OD/UPD/M/100/EDP | ODEON UPSIDE DOWN Men 100ml EDP |  |  | 0
2 | OD/UPD/W/100/EDP | ODEON UPSIDE DOWN Women 100ml ED |  |  | 0
3 | OD/MSQ/M/100/EDP | ODEON MOSAIQUE Men 100ml EDP |  |  | 192
4 | OD/MSQ/W/100/EDP | ODEON MOSAIQUE Women 100ml EDP |  |  | 336
5 | OD/COP/M/100/EDP | ODEON COPA Men 95ml EDP |  |  | 144
6 | OD/CAB/W/100/EDP | ODEON CABANA Women 95ml EDP |  |  | 144
7 | OD/SEN/M/100/EDP | ODEON SENATORE Men 100ml EDP |  |  | 144
8 | OD/SEN/W/100/EDP | ODEON SENATORE Women 100ml EDP |  |  | 144
9 | OD/ODM/M/125/EDP | ODEON MAN 125ml EDP |  |  | 6
10 | OD/ODL/W/125/EDP | ODEON LADY 125ml EDP |  |  | 6
11 | OD/ORI/M/100/EDP | ODEON ORIGAMI Men 100ml EDP |  |  | 6
12 | OD/ORI/W/100/EDP | ODEON ORIGAMI Women 100ml EDP |  |  | 6
 |  |  |  |  | 1128
 |  | ROI COLLECTION |  |  |  |  | *
1 | RO/DUK/M/100/EDP | ROI THE DUKE Men 100ml EDP |  |  | 0
2 | RO/INC/W/100/EDP | ROI INNOCENT Women 100ml EDP |  |  | 0
3 | RO/G&T/M/100/EDP | ROI GYM&TONIQ  Men 100ml EDP |  |  | 0
4 | RO/PPT/W/100/EDP | ROI PRESENT PERFECT Women 100ml |  |  | 240
5 | RO/ELE/M/100/EDP | ROI Electric Juice  Men |  |  | 0
6 | RO/VIB/W/100/EDP | Vibe Women |  |  | 480
 |  |  |  |  | 720
 |  | O/L & LUTECE |  |  |  |  | *
1 | OM/OML/M/100/EDP | OMBRE et LUMIERE Men 100ml EDP |  |  | 288
2 | OM/OML/W/100/EDP | OMBRE et LUMIERE Women 100ml EDP |  |  | 288
3 | OM/LUT/M/100/EDP | LUTECE Men 100ml EDP |  |  | 240
4 | OM/LUT/W/100/EDP | LUTECE Women 100ml EDP |  |  | 384
 |  |  |  |  | 1200
 |  | GRAND TOTAL: |  |  | 738166
 |  |  |  |  | TOTAL ORDERED