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

ENTITY - 100 ML - DE BEERS -
 |  |  | FINISH PRODUCT |  | BOTTLE |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | FG STOCK | To Produce | STOCK | ON ORDER | Stock after Production & On Order |  | [NAME] | 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 | WAY | EN/WAY/M/100/EDT |  |  |  |  |  | CAP/EC/DE/BLCK/100/EN/M | BLACK |  |  |  | UCN/ut/DE/WAY/100/EN/M |  |  |  | CON/ES/PINO/PLAY/GVENCHY/M |  |  |  | Essence
2 | JUST MAN | EN/JTM/M/100/EDT |  |  |  |  |  | CAP/EC/DE/BRWN/100/EN/M | BROWN |  |  |  | UCN/UT/DE/JTM/100/EN/M |  |  |  | CON/ES/CAMA/CH/CHRRA/M |  |  |  | Essence
3 | DEEPLY BLACK | EN/DLB/M/100/EDT |  |  |  |  |  | CAP/EC/DE/BLUE/100/EN/M | BLUE |  |  |  | UCN/UT/DE/DLB/100/EN/M |  |  |  | CON/ES/DJAN/BLCK/DNHIL/M |  |  |  | Essence
4 | ONLY FOR HIM | EN/OFH/M/100/EDT |  |  |  |  |  |  | BLUE |  |  |  | UCN/UT/DE/OFH/100/EN/M |  |  |  | CON/PB/DILA/OTB/DSEL/M |  |  |  | Perfume Boulevard
5 | GALLANT | EN/GAL/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/GAL/100/EN/M |  |  |  | CON/PB/GIUL/GUCCI2/GUCI/M |  |  |  | Perfume Boulevard
6 | MIDNIGHT | EN/MID/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/MID/100/EN/M |  |  |  | CON/AR/DUSK/LANUIT/YSL/M |  |  |  | [NAME]
7 | ALTITUDE EFFECT | EN/AEF/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/AEF/100/EN/M |  |  |  | CON/GF/67967/ATEXT/GOARM/M |  |  |  | Quintessence
8 | E'FRANCKY | EN/EFC/M/100/EDT |  |  |  |  |  |  | BLUE |  |  |  | UCN/ut/DE/EFC/100/EN/M |  |  |  | CON/AR/FRIN/EAUFRCH/VRSCE/M |  |  |  | [NAME]
9 | TUSK | EN/TSK/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/TSK/100/EN/M |  |  |  | CON/GR/30-6620/TUSC/ARAMIS/M |  |  |  | Grasse French
10 | PARODY POUR HOMME | EN/PRD/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/PRD/100/EN/M |  |  |  | CON/GR/30-4920/PARO/PRABN/M |  |  |  | Grasse French
11 | JUMP | EN/JMP/M/100/EDT |  |  |  |  |  |  | BLACK |  |  |  | UCN/UT/DE/JMP/100/EN/M |  |  |  | CON/AR/JOEL/JOOP/JOOP/M |  |  |  | [NAME]
12 | 9HUNDRED | EN/9HD/M/100/EDT |  |  |  |  |  |  | BROWN |  |  |  | UCN/UT/DE/9HD/100/EN/M |  |  |  | CON/AR/ARIS/900/ARAMIS/M |  |  |  | [NAME]
 | Total
 |  | BOT/PR/DE/CL/100/EC/M | Plain
 |  |  |  | Cutomer Name | Quantity
 | WAY | EN/WAY/M/100/EDT
 | JUST MAN | EN/JTM/M/100/EDT
 | DEEPLY BLACK | EN/DLB/M/100/EDT
 | ONLY FOR HIM | EN/OFH/M/100/EDT
 | GALLANT | EN/GAL/M/100/EDT
 | MIDNIGHT | EN/MID/M/100/EDT
 | ALTITUDE EFFECT | EN/AEF/M/100/EDT
 | E'FRANCKY | EN/EFC/M/100/EDT
 | TUSK | EN/TSK/M/100/EDT
 | PARODY POUR HOMME | EN/PRD/M/100/EDT
 | JUMP | EN/JMP/M/100/EDT |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/WAY/100/EN/M
 | 9HUNDRED | EN/9HD/M/100/EDT |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/JTM/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/DLB/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/OFH/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/GAL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/MID/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/AEF/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/EFC/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/TSK/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/PRD/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/JMP/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/9HD/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/DE/WAY/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/JTM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/DLB/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/OFH/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/GAL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/MID/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/AEF/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/DE/EFC/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/TSK/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/PRD/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/JMP/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/DE/9HD/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/WAY/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/JTM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/DLB/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/OFH/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/GAL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/MID/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/AEF/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/EFC/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/DE/TSK/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/PRD/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/JMP/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/DE/9HD/100/EN/M/FMF