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

Requirement of  Common Materials
 |  | Requirement | Buffer | stock | on order | Net Shortfall
FER/CI/15MM/GOLD | 15 [NAME] gold pump/ferrul
FER/CI/15MM/SLVR | 15 [NAME] silver pump/ferrul
FER/CI/20MM/slvr | 20 [NAME]  silver pump/ferrul
FER/CI/20MM/GOLD | 20 [NAME] gold pump/ferrul
COL/CI/15MM/GOLD/15MM | 15 [NAME] gold collar
COL/CI/15MM/SLVR/15MM | 15 [NAME] silver collar
LAB/KI/17MM/BLCK/30/EN/M&W | Entity 30 ml bottle  label
LAB/KI/17MM/BLCK/50/100/EN/M&W | Entity 50/100 ml  Bottle label
LAB/KI/20MM/BLCK/DC/M&W | Dream Bottle label
HOLOGRAM/AT/EN/15MM | [NAME] labels
HOLOGRAM/HH/DC | Dream  Hologram Labels
DY/CT/COT/BROWN | DYE BROWN R.M. 600 | 25
DY/CT/COT/GREEN | DYE GREEN G.L-450 | 50
DY/CT/COT/YELLOW | DYE [NAME] | 50
LQ/CT/COT/BLCK/MATT | LACQUER BLACK PAINT MATT ISOTRAP 355 | 200
LQ/CT/COT/CLER/GLOS | LACQUER CLEAR GLOSS ISOTRAP 350 | 3600
LQ/CT/COT/CLER/[NAME] | LACQUER CLEAR MATT ISOTRAP 351 (COLORTECH) | 200
PUP&ACT/AP/20MM/SLVR/106MM | PUMP & ACT - SILVER (20MMX106MM) - LUTECE MEN PUMP 31 MS 20MM SILVER PUMP W/A03L H6 TRANSPAREN
PUP&ACT/ER/NM/18MM/SLVR/92MM | PUMP & ACT -  SILVER (18MMX92MM) - (FBOG 92 MM)  - EMSAR
PUP&ACT/ER/NM/18MM/GOLD/92MM | PUMP & ACT -  GOLD (18MMX92MM) - GOLD (FBOG 92 MM)  - EMSAR
PUP&ACT/ER/18MM/SLVR | PUMP & ACT - 18MM - PUMP W/ACTUATOR UPSIDE DOWN MEN - 18MM - EMSAR
PUP&ACT/ER/18MM/GOLD | PUMP & ACT -  GOLD 18MM - W/ ACTUATOR  - 18MM - EMSAR
PUP&ACT/ID/15MM/GOLD/COM | PUMP & ACT - GOLD 15MM / CRIMP PUMP 90 MCL CMP GOLD - 15MHP 155/90 - IDENTISCENT
PUP&ACT/ID/15MM/SLVR/COM | PUMP & ACT - SILVER 15MM / CRIMP PUMP 90 MCL [NAME] 156/90 - IDENTISCENT
PUP&ACT/ID/20MM/SLVR/81MM | PUMP & ACT - SILVER (20MMX81MM) / 20MHP 2156/90+6.6MM VO4.1233BC/BCCMPARG. SILVER - IDENTISCEN
HOLOGRAM/HH/OD | LABEL HOLOGRAM HGE025 ODEON STICKER -25 MM X 15 MM ELLIPSE ROLL FORM - HYPERTECH
HOLOGRAM/HH/RO | LABEL HOLOGRAM ROI
HOLOGRAM/HH/OL | LABEL HOLOGRAM O/L
HOLOGRAM/HH/LU | LABEL HOLOGRAM HGS020 LUTECE STICKER -20 MM X 20 MM SQUARE GOLD FOIL - HYPERTECH
LAB/KI/20MM/GOLD/100/OD/W | LABEL  ODEON ROUND  - 100ML GOLD (DIA 20MM) - KIMOHA
LAB/KI/20MM/GOLD/95/OD/W | LABEL  ODEON ROUND - 95ML GOLD (DIA 20MM) (NEW)- KIMOHA
LAB/KI/20MM/GOLD/125/OD/W | LABEL  ODEON ROUND - 125ML GOLD (DIA 20MM) (NEW)- KIMOHA
LAB/KI/20MM/SLVR/100/OD/M | LABEL  ODEON ROUND - 100ML SILVER (DIA 20MM) - KIMOHA
LAB/KI/20MM/SLVR/95/OD/M | LABEL  ODEON ROUND  - 95ML SILVER (DIA 20MM) (NEW) - KIMOHA
LAB/KI/20MM/slvr/125/OD/M | LABEL  ODEON ROUND  - 125ML SILVER (DIA 20MM) (NEW) - KIMOHA
LAB/KI/25MM/GOLD/100/OL/W | [NAME]  - GOLD FOIL (DIA 25MM) - KIMOHA
LAB/KI/25MM/GOLD/100/RO/W | LABEL  ROI GOLD FOILING (DIA 25MM)  (NEW) - KIMOHA
LAB/KI/25MM/SLVR/100/OL/M | [NAME]  - SILVER FOIL (DIA 25MM) - KIMOHA
LAB/KI/25MM/SLVR/100/RO/M | LABEL  ROI SILVER FOILING (DIA 25MM)  (NEW) - KIMOHA
LAB/KI/25x17/GOLD/100/LU/W | LABEL  LUTECE WOMEN (25X17MM) GOLD - KIMOHA
LAB/KI/25x17/SLVR/100/LU/M | LABEL  LUTECE MEN (25X17MM) SILVER - KIMOHA (NEW) - KIMOHA
COL/su/18MM/GOLD/14MM | COLLAR - GOLD (18MMX14MM) - CACHE PUMP MEN - (sundip)
COL/CP/18MM/SLVR/14MM | [NAME] (18MMX14MM) - CACHE PUMP MEN  - (CAPINTER)
COL/ID/15MM/GOLD/13.5 | COLLAR - GOLD (15MMX13.5MM) / REGULAR SHROUD GOLD - SH G 15-13.5 - IDENTISCENT
COL/ID/15MM/SLVR/13.5 | [NAME] (15MMX13.5MM) / REGULAR SHROUD SILVER - SH G 15-13.5 - IDENTISCENT
COL/ID/15MM/SLVR/15 | [NAME] (15MMX15MM) / REGULAR SHROUD SILVER - SRD 15A15P144 - IDENTISCENT
PUP&ACT/ER/NW/18MM/GOLD/72MM | PUMP & ACT -  GOLD (18MMX72MM) - WISPY (FBOG 72 MM)  - EMSAR
PUP&ACT/ER/NW/18MM/SLVR/72MM | PUMP & ACT -  SILVER (18MMX72MM) - WISPY SILVER (FBOG 72MM)  - 18MM - EMSAR
 | STATUS OF PUMPS/LABELS
 | [NAME] | STOCK | ON ORDER
 | 15 MM SILVER PUMP
 | 20 MM GOLD PUMP
 | 20 MM SILVER PUMP
 | 15 MM GOLD PUMP
 | 15 MM GOLD COLLAR
 | 15 MM [NAME]
 | LABEL ENTITY 100 ML
 | LABEL ENTITY 30 ML
 | HOLOGRAM ENTITY
 | HOLOGRAM DREAM