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

ENTITY - 100 ML - TRIANGLE
 |  |  | 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 | [NAME] | EN/VIC/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/RDBR/100/EN/W | Red brown |  |  |  | UCN/UT/TR/VIC/100/EN/W |  |  |  | CON/PF/9/0500/4/EUPHORA/CK/W |  |  |  | Parfumania
2 | REALITY | EN/RTY/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/TUBL/100/EN/W | Turquise Blue |  |  |  | UCN/UT/TR/RTY/100/EN/W |  |  |  | CON/AR/LAUR/RLPHL/RLPHL/W |  |  |  | [NAME]
3 | MORE N MORE | EN/MOR/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/SLVR/100/EN/W | Silver |  |  |  | UCN/UT/TR/MOR/100/EN/W |  |  |  | CON/GF/51120/AMOR/CACHAREL/W |  |  |  | Quintessence
4 | BRIGHT BLUE FROST | EN/BRB/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/BRBL/100/EN/W | Bright Blue |  |  |  | UCN/UT/TR/BRB/100/EN/W |  |  |  | CON/AR/15112C/LTBLUE/D&G/W |  |  |  | [NAME]
5 | NAVE | EN/NAV/W/100/EDT |  |  |  |  |  |  |  | Silver |  |  |  | UCN/UT/TR/NAV/100/EN/W |  |  |  | CON/GF/51232/NINA/NINRICI/W |  |  |  | Quintessence
6 | COOL OFF WOMEN | EN/COL/W/100/EDT |  |  |  |  |  |  |  | Bright Blue |  |  |  | UCN/UT/TR/COL/100/EN/W |  |  |  | CON/AR/DEEPRIVER/EURO/W |  |  |  | [NAME]
7 | CLIMATIC | EN/CMT/W/100/EDT |  |  |  |  |  |  |  | Natural |  |  |  | UCN/UT/TR/CMT/100/EN/W |  |  |  | CON/ES/CARL/CLIMT/LNCOM/W |  |  |  | Essence
8 | 5 NUMBER | EN/5NM/W/100/EDT |  |  |  |  |  |  |  | Natural |  |  |  | UCN/UT/TR/5NM/100/EN/W |  |  |  | CON/SC/JANE/NO5/CHANEL/W |  |  |  | common Fragrance
9 | MAGIC WOMEN | EN/MGCW/W/100/EDT |  |  |  |  |  |  |  | Black |  |  |  | UCN/ut/TR/MGCW/100/EN/W |  |  |  | CON/ES/MARB/MGCNR/LNCOM/W |  |  |  | Essence
10 | ROCOCO | EN/ROCO/W/100/EDT |  |  |  |  |  |  |  | Natural |  |  |  | UCN/UT/TR/ROCO/100/EN/W |  |  |  | CON/GR/30/5272/COCO/CHANEL/W |  |  |  | Grasse
11 | WEEK IN  frost | EN/WEK/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/TRWT/100/EN/W | Natural |  |  |  | UCN/UT/TR/WEK/100/EN/W |  |  |  | CON/GR/30/4676/WKEND/BRBERY/W |  |  |  | Grasse
12 | FUJI | EN/FUJ/W/100/EDT |  |  |  |  |  |  | CAP/CH/TR/BLCK/100/EN/W | Black |  |  |  | UCN/UT/TR/FUJ/100/EN/W |  |  |  | CON/AR/BRMD/FIDJI/GYLROCH/W |  |  |  | [NAME]
 | Total | Total
 |  | BOT/PR/TR/CL/100/EN/W |  | Plain
 |  | BOT/PR/TR/FR/100/EN/W |  | Frost
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/VIC/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/RTY/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/MOR/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/BRB/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/NAV/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/COL/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/CMT/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/5NM/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/MGCW/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/ROCO/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/WEK/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/FUJ/100/EN/W
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/VIC/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/RTY/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/MOR/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/BRB/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/NAV/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/COL/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/CMT/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/5NM/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/ut/TR/MGCW/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/ROCO/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/WEK/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/UT/TR/FUJ/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/VIC/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/RTY/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/MOR/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/BRB/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/NAV/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/COL/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/CMT/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/5NM/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/MGCW/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/em/TR/ROCO/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/WEK/100/EN/W/FMF
 |  |  |  |  |  |  |  |  |  |  |  |  |  | UCN/EM/TR/FUJ/100/EN/W/FMF