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

SWISS PERFUMES FZE
Showroom Physical Stock Report
Have to be taken on Weekly Basis
 |  | On May 9, 2012
Product code | Material Description | Stock | [NAME]
Entity 30ml
EN/ALW/W/30/EDT | ENTITY COLLECTIONS ALWAYS SHINE Women 30ml EDT | 15 | Showroom Stocks
EN/CLT/W/30/EDT | ENTITY COLLECTIONS CLIMATIC Women 30ml EDT | 17 | Showroom Stocks
EN/DEL/W/30/EDT | ENTITY COLLECTIONS DELISH Women 30ml EDT | 11 | Showroom Stocks
EN/EDT/W/30/EDT | ENTITY COLLECTIONS ECLIPSE DU TEMPS Women 30ml EDT | 16 | Showroom Stocks
EN/ENC/W/30/EDT | ENTITY COLLECTIONS ENCHANT SHINE Women 30ml EDT | 15 | Showroom Stocks
EN/FUJ/W/30/EDT | ENTITY COLLECTIONS FUJI Women 30ml EDT | 17 | Showroom Stocks
EN/GRT/W/30/EDT | ENTITY COLLECTIONS GREEN TEEN Women 30ml EDT | 14 | Showroom Stocks
EN/HYP/W/30/EDT | ENTITY COLLECTIONS HYPNOTISME Women 30ml EDT | 11 | Showroom Stocks
EN/LBZ/W/30/EDT | ENTITY COLLECTIONS LIS BLANC ZONE Women 30ml EDT | 17 | Showroom Stocks
EN/LFR/W/30/EDT | ENTITY COLLECTIONS LEAF IN RED Women 30ml EDT | 17 | Showroom Stocks
EN/LIF/W/30/EDT | ENTITY COLLECTIONS LIFE AND LOVE Women 30ml EDT | 15 | Showroom Stocks
EN/MAG/W/30/EDT | ENTITY COLLECTIONS MAGIC NOYAU Women 30ml EDT | 13 | Showroom Stocks
EN/SSB/W/30/EDT | ENTITY COLLECTIONS SHINE SO BRIGHT Women 30ml EDT | 16 | Showroom Stocks
EN/WEK/W/30/EDT | ENTITY COLLECTIONS WEEK IN Women 30ml EDT | 13 | Showroom Stocks
EN/WTC/W/30/EDT | ENTITY COLLECTIONS WHITE CLOUDS Women 30ml EDT | 16 | Showroom Stocks
Entity 50ml
EN/DEC/W/50/EDT | ENTITY COLLECTIONS DECODEL Women 50ml EDT | 10 | Showroom Stocks
EN/BPR/W/50/EDT | ENTITY COLLECTIONS BE PRECISE Women 50ml EDT | 16 | Showroom Stocks
EN/ALT/W/50/EDT | ENTITY COLLECTIONS ALTADORE Women 50ml EDT | 14 | Showroom Stocks
EN/ICL/W/50/EDT | ENTITY COLLECTIONS ICE COOL Women 50ml EDT | 10 | Showroom Stocks
EN/EVM/W/50/EDT | ENTITY COLLECTIONS EVER MORE Women 50ml EDT | 11 | Showroom Stocks
EN/ECP/W/50/EDT | ENTITY COLLECTIONS ECLIPS Women 50ml EDT | 17 | Showroom Stocks
EN/E03/W/50/EDT | ENTITY COLLECTIONS E 203 Women 50ml EDT | 15 | Showroom Stocks
EN/LVF/W/50/EDT | ENTITY COLLECTIONS LOVE FOR Women 50ml EDT | 12 | Showroom Stocks
EN/EDT/W/50/EDT | ENTITY COLLECTIONS ECLIPSE DU TEMPS Women 50ml EDT | 13 | Showroom Stocks
EN/DEL/W/50/EDT | ENTITY COLLECTIONS DELISH Women 50ml EDT | 14 | Showroom Stocks
EN/NIN/W/50/EDT | ENTITY COLLECTIONS NINEL Women 50ml EDT | 9 | Showroom Stocks
EN/LIF/W/50/EDT | ENTITY COLLECTIONS LIFE AND LOVE Women 50ml EDT | 13 | Showroom Stocks
EN/TKP/W/50/EDT | ENTITY COLLECTIONS TAKE PINK Women 50ml EDT | 8 | Showroom Stocks
EN/OOI/W/50/EDT | ENTITY COLLECTIONS ONE2 ON ICE Women 50ml EDT | 14 | Showroom Stocks
EN/WTC/W/50/EDT | ENTITY COLLECTIONS WHITE CLOUDS Women 50ml EDT | 15 | Showroom Stocks
EN/LVM/W/50/EDT | ENTITY COLLECTIONS LOVING MORE Women 50ml EDT | 13 | Showroom Stocks
EN/SSB/W/50/EDT | ENTITY COLLECTIONS SHINE SO BRIGHT Women 50ml EDT | 13 | Showroom Stocks
EN/MYP/W/50/EDT | ENTITY COLLECTIONS MY PASSION Women 50ml EDT | 10 | Showroom Stocks
EN/TFN/W/50/EDT | ENTITY COLLECTIONS THE FUN Women 50ml EDT | 12 | Showroom Stocks
EN/NAN/W/50/EDT | ENTITY COLLECTIONS NANCI Women 50ml EDT | 17 | Showroom Stocks
EN/DLT/W/50/EDT | ENTITY COLLECTIONS DELIGHT Women 50ml EDT | 15 | Showroom Stocks
EN/SUB/W/50/EDT | ENTITY COLLECTIONS SUBMISS Women 50ml EDT | 14 | Showroom Stocks
EN/RLF/W/50/EDT | ENTITY COLLECTIONS REAL LIFE Women 50ml EDT | 9 | Showroom Stocks
EN/LFR/W/50/EDT | ENTITY COLLECTIONS LEAF IN RED Women 50ml EDT | 15 | Showroom Stocks
EN/BLB/W/50/EDT | ENTITY COLLECTIONS BLUE BELLS Women 50ml EDT | 12 | Showroom Stocks
EN/LBZ/W/50/EDT | ENTITY COLLECTIONS LIS BLANC ZONE Women 50ml EDT | 14 | Showroom Stocks
EN/ALW/W/50/EDT | ENTITY COLLECTIONS ALWAYS SHINE Women 50ml EDT | 13 | Showroom Stocks
EN/HAP/W/50/EDT | ENTITY COLLECTIONS HAPPY WOMEN Women 50ml EDT | 8 | Showroom Stocks
EN/PRP/W/50/EDT | ENTITY COLLECTIONS PROPOSE Women 50ml EDT |  | Showroom Stocks
EN/GRT/W/50/EDT | ENTITY COLLECTIONS GREEN TEEN Women 50ml EDT |  | Showroom Stocks
EN/18T/W/50/EDT | ENTITY COLLECTIONS 18 TH CEREMONY Women 50ml EDT |  | Showroom Stocks
EN/KEE/W/50/EDT | ENTITY COLLECTIONS KEEN Women 50ml EDT |  | Showroom Stocks
EN/EXC/W/50/EDT | ENTITY COLLECTIONS EXCESS Women 50ml EDT |  | Showroom Stocks
EN/MUS/W/50/EDT | ENTITY COLLECTIONS MUSICAL Women 50ml EDT |  | Showroom Stocks
EN/ACR/W/50/EDT | ENTITY COLLECTIONS ACROSS Women 50ml EDT |  | Showroom Stocks
EN/FLR/W/50/EDT | ENTITY COLLECTION FLORAL Women 50 ml EDT |  | Showroom Stocks
EN/PLX/W/50/EDT | ENTITY COLLECTIONS PREMIUM LUX Women 50ml EDT |  | Showroom Stocks
EN/GLM/W/50/EDT | ENTITY COLLECTIONS GLAMORIZE Women 50ml EDT |  | Showroom Stocks
EN/FBE/W/50/EDT | ENTITY COLLECTIONS FLORALE BY ENTITY Women 50ml EDT |  | Showroom Stocks
EN/CHW/W/50/EDT | ENTITY COLLECTIONS CHANCY WOMEN Women 50ml EDT |  | Showroom Stocks
EN/DRO/W/50/EDT | ENTITY COLLECTIONS DOLCETTO ROSE THE ONE Women 50ml EDT |  | Showroom Stocks
Entity 100ml
EN/BGL/W/100/EDT | ENTITY COLLECTIONS BLACK GLAMOUR WOMEN 100ml EDT | 11 | Showroom Stocks
EN/CCL/W/100/EDT | ENTITY COLLECTIONS CHERY CHERY LADY WOMEN 100ml EDT | 15 | Showroom Stocks
EN/FLO/W/100/EDT | ENTITY COLLECTIONS FLORENCE WOMEN 100ml EDT | 13 | Showroom Stocks
EN/PRT/W/100/EDT | ENTITY COLLECTIONS PRETTY PRETTY WOMEN 100ml EDT | 5 | Showroom Stocks
EN/SPR/W/100/EDT | ENTITY COLLECTIONS SAPPHIRE WOMEN 100ml EDT | 13 | Showroom Stocks
EN/TRS/W/100/EDT | ENTITY COLLECTIONS THE ROSE WOMEN 100ml EDT | 8 | Showroom Stocks
EN/DOR/W/100/EDT | ENTITY COLLECTIONS DREAM ON ROCKS WOMEN 100ml EDT | 14 | Showroom Stocks
EN/IDO/W/100/EDT | ENTITY COLLECTIONS I DOLLY WOMEN 100ml EDT | 13 | Showroom Stocks
EN/ORN/W/100/EDT | ENTITY COLLECTIONS ORANGE WOMEN 100ml EDT | 14 | Showroom Stocks
EN/VER/W/100/EDT | ENTITY COLLECTIONS VERSAILLES WOMEN 100ml EDT | 9 | Showroom Stocks
EN/MGCW/W/100/EDT | ENTITY COLLECTIONS MAGIC WOMEN WOMEN 100ML EDT | 14 | Showroom Stocks
EN/WEK/W/100/EDT | ENTITY COLLECTIONS WEEK IN WOMEN 100ML EDT | 9 | Showroom Stocks
EN/ROCO/W/100/EDT | ENTITY COLLECTIONS ROCOCO WOMEN 100ML EDT | 5 | Showroom Stocks
EN/5NM/W/100/EDT | ENTITY COLLECTIONS 5 NUMBER WOMEN 100ML EDT | 4 | Showroom Stocks
EN/FUJ/W/100/EDT | ENTITY COLLECTIONS FUJI WOMEN 100ML EDT | 11 | Showroom Stocks
EN/CMT/W/100/EDT | ENTITY COLLECTIONS CLIMATIC WOMEN 100ML EDT | 9 | Showroom Stocks
EN/GDG/M/100/EDT | ENTITY COLLECTIONS GOOD GUY Men 100ml EDT | 6 | Showroom Stocks
EN/BLB/M/100/EDT | ENTITY COLLECTIONS BLACK BELT Men 100ml EDT | 2 | Showroom Stocks
EN/ACR/M/100/EDT | ENTITY COLLECTIONS ACROSS Men 100ml EDT | 9 | Showroom Stocks
EN/DFN/M/100/EDT | ENTITY COLLECTIONS DEFENCE Men 100ml EDT | 12 | Showroom Stocks
EN/BAM/M/100/EDT | ENTITY COLLECTIONS BIGAMBITION Men 100ml EDT | 6 | Showroom Stocks
EN/DVG/M/100/EDT | ENTITY COLLECTIONS DIVING SUIT Men 100ml EDT | 5 | Showroom Stocks
EN/DHS/M/100/EDT | ENTITY COLLECTIONS DAILY HOMME SPORT Men 100ml EDT | 10 | Showroom Stocks
EN/DLT/M/100/EDT | ENTITY COLLECTIONS DOLCETTO Men 100ml EDT | 10 | Showroom Stocks
EN/FGT/M/100/EDT | ENTITY COLLECTIONS FIRE GATE Men 100ml EDT | 11 | Showroom Stocks
EN/GBL/M/100/EDT | ENTITY COLLECTIONS GIVEN BLUE LEVEL Men 100ml EDT | 7 | Showroom Stocks
EN/AZN/M/100/EDT | ENTITY COLLECTIONS AIR ZONE Men 100ml EDT | 4 | Showroom Stocks
EN/DTO/M/100/EDT | ENTITY COLLECTIONS DOLCETTO THE ONE Men 100ml EDT | 4 | Showroom Stocks
EN/CKM/M/100/EDT | ENTITY COLLECTIONS CAREER MAN Men 100ml EDT | 4 | Showroom Stocks
EN/COL/M/100/EDT | ENTITY COLLECTIONS COOL OFF MEN Men 100ml EDT | 2 | Showroom Stocks
EN/ACT/M/100/EDT | ENTITY COLLECTIONS ACTION SPORTS Men 100ml EDT | 11 | Showroom Stocks
EN/AQU/M/100/EDT | ENTITY COLLECTIONS AQUA ZONE Men 100ml EDT | 10 | Showroom Stocks
EN/BON/M/100/EDT | ENTITY COLLECTIONS BON AQUA Men 100ml EDT | 6 | Showroom Stocks
EN/EXL/M/100/EDT | ENTITY COLLECTIONS EXCEL Men 100ml EDT | 13 | Showroom Stocks
EN/PAL/M/100/EDT | ENTITY COLLECTIONS PALADIUM ELITE Men 100ml EDT | 11 | Showroom Stocks
EN/MOV/M/100/EDT | ENTITY COLLECTIONS MOVE ENERGY Men 100ml EDT | 6 | Showroom Stocks
EN/BAS/M/100/EDT | ENTITY COLLECTIONS BASE CODE Men 100ml EDT | 6 | Showroom Stocks
EN/FIR/M/100/EDT | ENTITY COLLECTIONS FIRE GATE ABSOLUTION Men 100ml EDT | 6 | Showroom Stocks
EN/BRB/W/100/EDT | ENTITY COLLECTIONS BRIGHT BLUE Women 100ml EDT | 13 | Showroom Stocks
EN/VIC/W/100/EDT | ENTITY COLLECTIONS VICTORIA Women 100ml EDT | 9 | Showroom Stocks
EN/NAV/W/100/EDT | ENTITY COLLECTIONS NAVE Women 100ml EDT | 7 | Showroom Stocks
EN/MOR/W/100/EDT | ENTITY COLLECTIONS MORE & MORE Women 100ml EDT | 6 | Showroom Stocks
EN/RTY/W/100/EDT | ENTITY COLLECTIONS REALITY Women 100ml EDT | 12 | Showroom Stocks
EN/COL/W/100/EDT | ENTITY COLLECTIONS COOL OFF W Women 100ml EDT | 10 | Showroom Stocks
EN/WAY/M/100/EDT | ENTITY COLLECTIONS WAY MEN 100ML EDT | 14 | Showroom Stocks
EN/JTM/M/100/EDT | ENTITY COLLECTIONS JUST MAN MEN 100ML EDT | 8 | Showroom Stocks
EN/DLB/M/100/EDT | ENTITY COLLECTIONS DEEPLY BLACK MEN 100ML EDT | 13 | Showroom Stocks
EN/OFH/M/100/EDT | ENTITY COLLECTIONS ONLY FOR HIM MEN 100ML EDT | 11 | Showroom Stocks
EN/GAL/M/100/EDT | ENTITY COLLECTIONS GALLANT MEN 100ML EDT | 1 | Showroom Stocks
EN/MID/M/100/EDT | ENTITY COLLECTIONS MIDNIGHT MEN 100ML EDT | 11 | Showroom Stocks
EN/AEF/M/100/EDT | ENTITY COLLECTIONS ALTITUDE EFFECT MEN 100ML EDT | 7 | Showroom Stocks
EN/EFC/M/100/EDT | ENTITY COLLECTIONS E'FRANCKY MEN 100ML EDT | 12 | Showroom Stocks
EN/TSK/M/100/EDT | ENTITY COLLECTIONS TUSK MEN 100ML EDT | 12 | Showroom Stocks
EN/PRD/M/100/EDT | ENTITY COLLECTIONS PARODY POUR HOMME MEN 100ML EDT | 12 | Showroom Stocks
EN/JMP/M/100/EDT | ENTITY COLLECTIONS JUMP MEN 100ML EDT | 10 | Showroom Stocks
EN/VNT/W/100/EDT | ENTITY COLLECTIONS VANITY WOMEN 100ML EDT | 14 | Showroom Stocks
EN/DEW/W/100/EDT | ENTITY COLLECTIONS DEW WOMEN 100ML EDT | 8 | Showroom Stocks
EN/DBR/W/100/EDT | ENTITY COLLECTIONS DEBONAIRE WOMEN 100ML EDT | 5 | Showroom Stocks
EN/ABT/W/100/EDT | ENTITY COLLECTIONS ABILITY WOMEN 100ML EDT | 7 | Showroom Stocks
EN/9HD/M/100/EDT | ENTITY COLLECTIONS 9HUNDRED MEN 100ML EDT | 13 | Showroom Stocks
Dream Collection
DR/COD/M/100/EDT | DREAM COLLECTIONS COOL DUDE Men 100ml EDT | 3 | Showroom Stocks
DR/EGO/M/100/EDT | DREAM COLLECTIONS EGO Men 100ml EDT | 10 | Showroom Stocks
DR/END/M/100/EDT | DREAM COLLECTIONS ENDORSE Men 100ml EDT | 11 | Showroom Stocks
DR/BLC/M/100/EDT | DREAM COLLECTIONS BLACK CAP Men 100ml EDT | 7 | Showroom Stocks
DR/AQU/M/100/EDT | DREAM COLLECTIONS AQUILON Men 100ml EDT | 15 | Showroom Stocks
DR/FLH/M/100/EDT | DREAM COLLECTIONS FLY HIGH Men 100ml EDT | 15 | Showroom Stocks
DR/KEN/W/100/EDT | DREAM COLLECTIONS KENMORE Women 100ml EDT | 12 | Showroom Stocks
DR/RST/W/100/EDT | DREAM COLLECTIONS REAL STORY Women 100ml EDT | 5 | Showroom Stocks
DR/CHT/W/100/EDT | DREAM COLLECTIONS CHAT Women 100ml EDT | 7 | Showroom Stocks
DR/SPL/W/100/EDT | DREAM COLLECTIONS SPLENDORE Women 100ml EDT | 10 | Showroom Stocks
DR/JIN/W/100/EDT | DREAM COLLECTIONS JINGLE Women 100ml EDT | 7 | Showroom Stocks
DR/SOM/W/100/EDT | DREAM COLLECTIONS SOME MORE Women 100ml EDT | 13 | Showroom Stocks
DR/MIL/M/100/EDT | DREAM COLLECTIONS MILLIONAIRE Men 100ml EDT | 11 | Showroom Stocks
DR/TRT/M/100/EDT | DREAM COLLECTIONS TREAT Men 100ml EDT | 15 | Showroom Stocks
DR/SEN/W/100/EDT | DREAM COLLECTIONS SENSIBLE ME Women 100ml EDT | 8 | Showroom Stocks
DR/HRP/W/100/EDT | DREAM COLLECTIONS HER PASSION Women 100ml EDT | 7 | Showroom Stocks
DR/RAW/W/100/EDT | DREAM COLLECTIONS RED AND WHITE Women 100ml EDT | 8 | Showroom Stocks
DR/DGR/W/100/EDT | [NAME] JUST ONE Women 100ml EDT | 10 | Showroom Stocks
DR/JSH/M/100/EDT | DREAM COLLECTIONS JUST HOMME SPORT Men 100ml EDT | 13 | Showroom Stocks
DR/OBO/M/100/EDT | DREAM COLLECTIONS ONE BY ONE JUST ICE Men 100ml EDT | 10 | Showroom Stocks
DR/DDG/M/100/EDT | [NAME] JUST ONE Men 100ml EDT | 5 | Showroom Stocks
DR/OBO/W/100/EDT | DREAM COLLECTIONS ONE BY ONE JUST ICE Women 100ml EDT | 5 | Showroom Stocks
DR/JAD/W/100/EDT | DREAM COLLECTIONS JUST ADDICTION SHINE Women 100ml EDT | 3 | Showroom Stocks
DR/DUT/W/100/EDT | DREAM COLLECTIONS DUET Women 100ml EDT | 1 | Showroom Stocks
DR/RKT/W/100/EDT | DREAM COLLECTIONS RED KNOT Women 100ml EDT | 1 | Showroom Stocks
DR/EXP/W/100/EDT | DREAM COLLECTIONS EXPOSE Women 100ml EDT | 1 | Showroom Stocks
DR/NCH/W/100/EDT | DREAM COLLECTIONS NICE CHANCE Women 100ml EDT | 1 | Showroom Stocks
DR/POM/W/100/EDT | DREAM COLLECTIONS POEM Women 100ml EDT | 1 | Showroom Stocks
DR/IDE/W/100/EDT | DREAM COLLECTIONS IDLE Women 100ml EDT | 1 | Showroom Stocks
DR/SPH/M/100/EDT | DREAM COLLECTIONS SPHERE Men 100ml EDT | 2 | Showroom Stocks
DR/AGT/M/100/EDT | DREAM COLLECTIONS A GENT Men 100ml EDT | 2 | Showroom Stocks
DR/FST/M/100/EDT | DREAM COLLECTIONS FIRE SIGHT Men 100ml EDT | 1 | Showroom Stocks
DR/RAG/M/100/EDT | DREAM COLLECTIONS RANGE Men 100ml EDT | 1 | Showroom Stocks
DR/DBL/M/100/EDT | DREAM COLLECTIONS DOUBLE Men 100ml EDT | 1 | Showroom Stocks
DR/MLY/M/100/EDT | DREAM COLLECTIONS MANLY MAN Men 100ml EDT | 3 | Showroom Stocks
ROI Collection
RO/G&T/M/100/EDP | ROI COLLECTIONS GYM&TONIQ Men 100ml EDP | 2 | Showroom Stocks
RO/PPT/W/100/EDP | ROI COLLECTIONS PRESENT PERFECT Women 100ml EDP | 1 | Showroom Stocks
RO/DUK/M/100/EDP | ROI COLLECTIONS THE DUKE Men 100ml EDP | 11 | Showroom Stocks
RO/INC/W/100/EDP | ROI COLLECTIONS INNOCENT Women 100ml EDP | 10 | Showroom Stocks
RO/VIB/W/100/EDP | ROI COLLECTIONS VIBE WOMEN 100ML EDP | 1 | Showroom Stocks
RO/ELE/M/100/EDP | ROI COLLECTIONS ELECTRIC JUICE MEN 100ML EDP | 6 | Showroom Stocks
Odeon Collection
OD/COP/M/100/EDP | ODEON COLLECTIONS COPA Men 95ml EDP | 13 | Showroom Stocks
OD/CAB/W/100/EDP | ODEON COLLECTIONS CABANA Women 95ml EDP | 7 | Showroom Stocks
OD/MSQ/M/100/EDP | ODEON COLLECTIONS MOSAIQUE Men 100ml EDP | 10 | Showroom Stocks
OD/MSQ/W/100/EDP | ODEON COLLECTIONS MOSAIQUE Women 100ml EDP | 11 | Showroom Stocks
OD/UPD/M/100/EDP | ODEON COLLECTIONS UPSIDE DOWN Men 100ml EDP | 11 | Showroom Stocks
OD/UPD/W/100/EDP | ODEON COLLECTIONS UPSIDE DOWN Women 100ml EDP | 9 | Showroom Stocks
OD/SEN/M/100/EDP | ODEON COLLECTIONS SENATORE Men 100ml EDP | 7 | Showroom Stocks
OD/SEN/W/100/EDP | ODEON COLLECTIONS SENATORE Women 100ml EDP | 5 | Showroom Stocks
OD/ODL/W/125/EDP | ODEON COLLECTIONS ODEON LADY Women 125ml EDP | 3 | Showroom Stocks
OD/ODM/M/125/EDP | ODEON COLLECTIONS ODEON MAN Men 125ml EDP | 1 | Showroom Stocks
OD/ORI/W/100/EDP | ODEON COLLECTIONS ORIGAMI Women 100ml EDP | 6 | Showroom Stocks
OD/ORI/M/100/EDP | ODEON COLLECTIONS ORIGAMI Men 100ml EDP | 6 | Showroom Stocks
O/L & Lutece
OM/OML/M/100/EDP | OMBRE et LUMIERE Men 100ml EDP | 4 | Showroom Stocks
OM/OML/W/100/EDP | OMBRE et LUMIERE Women 100ml EDP | 8 | Showroom Stocks
OM/LUT/M/100/EDP | LUTECE (M) 900 100ml | 11 | Showroom Stocks
OM/LUT/W/100/EDP | LUTECE (W) 901 100 ml | 8 | Showroom Stocks
Total: