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

ENTITY - 100ml- SOGO
 |  |  | FINISH PRODUCT |  |  | BOTTLE |  |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | FG STOCK | To Produce |  | STOCK | ON ORDER | Stock after Production & On Order |  | CAP 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 | GOOD GUY | EN/GDG/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/BLCK/100/EN/M/NO INSERT | BLACK |  |  |  | UCN/EM/SO/GDG/100/EN/M |  |  |  | CON/GF/51259/HXY/HBOSS/M |  |  |  | Quintessence
2 | DIVING SUIT | EN/DVG/M/100/EDT |  |  |  |  |  |  |  | SILVER |  |  |  | UCN/EM/SO/DVG/100/EN/M |  |  |  | CON/VM/FLWR/PRSUIT/DNHIL/M |  |  |  | V Mane Fils
3 | ACROSS - FROST | EN/ACR/M/100/EDT |  |  |  |  |  |  |  | SILVER |  |  |  | UCN/EM/SO/ACR/100/EN/M |  |  |  | CON/GR/BLCH/BOS98/HBOSS/M |  |  |  | Grasse French
4 | [NAME] | EN/DFN/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SO/DFN/100/EN/M |  |  |  | CON/SC/HRCL/DRINTNS/DIOR/M |  |  |  | [NAME]
5 | BLACK BELT | EN/BLB/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SO/BLB/100/EN/M |  |  |  | CON/AF/22147/DRKNR/GYLROCH/M |  |  |  | [NAME]
6 | BIG AMBITION | EN/BAM/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/SLVR/100/EN/M/NO INSERT | SILVER |  |  |  | UCN/EM/SO/BAM/100/EN/M |  |  |  | CON/VM/MNCH/BOSSLC/HBOSS/M |  |  |  | V Mane Fils
7 | AIR ZONE | EN/AZN/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/WHIT/100/EN/M/NO INSERT | WHITE |  |  |  | UCN/EM/SO/AZN/100/EN/M |  |  |  | CON/ES/ELEV/LPARK/KENZO/M |  |  |  | Essence
8 | FIRE GATE | EN/FGT/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SO/FGT/100/EN/M |  |  |  | CON/AF/14719/FHRENHT/DIOR/M |  |  |  | Grasse French
9 | DOLCETTO | EN/DLT/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/NABU/100/EN/M/NO INSERT | NAVY BLUE |  |  |  | UCN/EM/SO/DLT/100/EN/M |  |  |  | CON/ES/DON/THE1/D&G/M |  |  |  | Essence
10 | DAILY HOME SPORT | EN/DHS/M/100/EDT |  |  |  |  |  |  |  | BLACK |  |  |  | UCN/EM/SO/DHS/100/EN/M |  |  |  | CON/ES/DESM/DIORHMSP/DIOR/M |  |  |  | Essence
11 | GIVEN BLUE LEVEL | EN/GBL/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/SBLU/100/EN/M/NO INSERT | SKY BLUE |  |  |  | UCN/EM/SO/GBL/100/EN/M |  |  |  | CON/PF/9-0325-3/BLULBL/GIVCHY/M |  |  |  | V Mane Fils
12 | DOLCETTO THE ONE | EN/DTO/M/100/EDT |  |  |  |  |  |  | CAP/CH/SO/RDBR/100/EN/M/NO INSERT | BROWN |  |  |  | UCN/EM/SO/DTO/100/EN/M |  |  |  | CON/QU/69650/D&G1/D&G/M |  |  |  | Quintessence
 | Total
 |  | BOT/PR/SO/FR/100/EN/M |  | FROSTED
 |  | BOT/PR/SO/CL/100/EN/M |  | PLAIN
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/GDG/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/DVG/100/EN/M |  |  |  | CON/GR/32-9274/DRKNR/GYLROCH/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/ACR/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/DFN/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/BLB/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/BAM/100/EN/M
 |  |  |  |  |  |  |  |  |  | ` |  |  |  | UCN/UT/SO/AZN/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/FGT/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DLT/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DHS/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/GBL/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DTO/100/EN/M
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/GDG/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/DVG/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/ACR/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/DFN/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/BLB/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/BAM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/AZN/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/FGT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/DLT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/DHS/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/GBL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/SO/DTO/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/GDG/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/DVG/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/ACR/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/DFN/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/BLB/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/SO/BAM/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/AZN/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/FGT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DLT/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DHS/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/GBL/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/SO/DTO/100/EN/M/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/TL/SO/DVG/100/EN/M