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

ENTITY -100 ML - ASPIRE
 |  |  | FINISH PRODUCT |  |  | BOTTLE |  |  |  | CAPS |  |  |  |  | UNIT CARTON |  |  |  | CONCENTRATE
Sr.No. | VARIANT NAME |  | FG 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 | Sapphire | EN/SPR/W/100/EDT |  |  |  |  |  |  | CAP/EC/SLVR/100/EN/W | Silver |  |  |  | UCN/sg/AS/SPR/100/EN/W |  |  |  | CON/QU/69653/DMND/EMPARMNI/W |  |  |  | Quintsnce
2 | Pretty Pretty | EN/PRT/W/100/EDT |  |  |  |  |  |  | CAP/EC/RERO/100/EN/W | [NAME] |  |  |  | UCN/SG/AS/PRT/100/EN/W |  |  |  | CON/AR/RDRB/RICCI/NINA/W |  |  |  | [NAME]
3 | I'Dolly d'Entity | EN/IDO/W/100/EDT |  |  |  |  |  |  | CAP/EC/GOLD/100/EN/W | Gold |  |  |  | UCN/SG/AS/IDO/100/EN/W |  |  |  | CON/ES/IDA/IDLE/ARMNI/W |  |  |  | Essences
4 | Chery Chery Lady | EN/CCL/W/100/EDT |  |  |  |  |  |  | CAP/EC/SLVR/100/EN/W | Silver |  |  |  | UCN/sg/AS/CCL/100/EN/W |  |  |  | CON/FI/193933/MDCL/DIOR/W |  |  |  | Firmenich
5 | Dreams on Rocks | EN/DOR/W/100/EDT |  |  |  |  |  |  | CAP/EC/WHIT/100/EN/W | White |  |  |  | UCN/SG/AS/DOR/100/EN/W |  |  |  | CON/AR/BFDR/RKDR/VLNTNO/W |  |  |  | [NAME]
6 | Orange | EN/ORN/W/100/EDT |  |  |  |  |  |  | CAP/EC/ORNG/100/EN/W | Dark Orange |  |  |  | UCN/sg/AS/ORN/100/EN/W |  |  |  | CON/AR/CKRS/HGBO/BOOR/W |  |  |  | [NAME]
7 | Versailles | EN/VER/W/100/EDT |  |  |  |  |  |  | CAP/EC/SLVR/100/EN/W | Silver |  |  |  | UCN/sg/AS/VER/100/EN/W |  |  |  | CON/AR/CMNT/VRSC/VERS/W |  |  |  | [NAME]
8 | Florence | EN/FLO/W/100/EDT |  |  |  |  |  |  | CAP/EC/BLACK/100/EN/W | Black |  |  |  | UCN/SG/AS/FLO/100/EN/W |  |  |  | CON/ES/FARA/GUCIFLR/GUCI/W |  |  |  | Essences
9 | The Rose | EN/TRS/W/100/EDT |  |  |  |  |  |  | CAP/EC/BGSL/100/EN/W | Light Brown |  |  |  | UCN/SG/AS/TRS/100/EN/W |  |  |  | CON/AR/ROEX/D&GRSTHE1/D&G/W |  |  |  | [NAME]
10 | Black Glamour | EN/BGL/W/100/EDT |  |  |  |  |  |  | CAP/EC/BLACK/100/EN/W | Black |  |  |  | UCN/sg/AS/BGL/100/EN/W |  |  |  | CON/AR/INKW/ENNO/LLQE/W |  |  |  | [NAME]
 | Total
 |  | BOT/PR/AS/CL/100/EN/W | Bottle
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/SPR/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/PRT/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/IDO/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/CCL/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/DOR/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/ORN/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/VER/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/FLO/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/TRS/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/BGL/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/sg/AS/SPR/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/SG/AS/PRT/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/SG/AS/IDO/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/sg/AS/CCL/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/SG/AS/DOR/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/sg/AS/ORN/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/sg/AS/VER/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/SG/AS/FLO/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/SG/AS/TRS/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/sg/AS/BGL/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/SPR/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/PRT/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/IDO/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/CCL/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/DOR/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/ORN/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/VER/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/FLO/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/TRS/100/EN/W/fmf
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/AS/BGL/100/EN/W/fmf