Spreadsheet: 547514d1510595051-vlookup-and-index-match-function-2-sheets-stock-analysis
Sheet: Sheet2

 |  | 2015 |  |  |  |  |  |  |  |  |  |  |  | 2016 |  |  |  |  |  |  |  |  |  |  |  | 2017
 |  | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00 | 2016-03-01 00:00:00 | 2016-04-01 00:00:00 | 2016-05-01 00:00:00 | 2016-06-01 00:00:00 | 2016-07-01 00:00:00 | 2016-08-01 00:00:00 | 2016-09-01 00:00:00 | 2016-10-01 00:00:00 | 2016-11-01 00:00:00 | 2016-12-01 00:00:00 | 2017-01-01 00:00:00 | 2017-02-01 00:00:00 | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00
100016 | TRANSFORMERLTT75310FIN440 -OUT 24V 75VA
100287 | [NAME]" FOR DAMPER
100288 | QUADRANT HANDLE SMALL 3/8" FOR DAMPER
100289 | ROUND HANDLE FOR DAMPER
100290 | SPLITTER BRACKET SPR40 FOR DAMPER
100292 | SQUARE END BAR FOR DAMPER
101451 | BRASS ROUND ROD 25MM DIA
101457 | KUT KUT (JUTE)
101458 | SELF ADHESIVE HANGER
101460 | TEFLON TAPE THREAD SEAL 12MMX0.075MMX10M
101461 | WELDING ROD 2.5MM X350MM E6013
101466 | WELDING ROD 3.2MM X350MM E6013 PACK162
101482 | PAINT BRUSH 3"
101484 | PAINT BRUSH 2"
101485 | PAINT BRUSH 4"
101491 | PROTECTIVE COATING LACQUER THINNER NAT
101495 | THINNER SUPER 888
101497 | SECURITY HOLOGRAM LABELS 15X15MM
101498 | SHIRT W/ALGHANIM LOGO
101500 | SHRINK WRAP PLASTIC-PACKING ROLL
101546 | THREADED ROD GI 10MMX2M
101547 | THREADED ROD GI 12MMX2M
101552 | THREADED ROD GI 6MMX2M
101553 | THREADED ROD GI 8MMX2M
101574 | NUT GI 1/2" 2BA (PKT100)
101576 | NUT GI 10MM
101577 | NUT GI 12MM
101583 | NUT GI 6MM
101584 | NUT GI 8MM
101586 | POP RIVET ALUM 1/8 X 3/8" PACK1000
101587 | POP RIVET ALUM 4X12MM
101596 | SCREW GI 3/4" 2BA FLAT SLOT COUNTERSUNK
101603 | SHEET METAL SCREW 1"X10 PHILIPS SLOT
101604 | SHEET METAL SCREW 1/2"X10 PHILIPS SLOT
101606 | SHEET METAL SCREW 11/2" PHILIPS SLOT
101607 | SHEET METAL SCREW 2" PHILIPS SLOT
101608 | SHEET METAL SCREW 21/2"X10 PHILIPS SLOT
101609 | SHEET METAL SCREW 3/4"X10 PHILIPS SLOT
101612 | GUN NAIL PASLODE  2"X0.086
101613 | PLASTIC FISHER NO 6 RAWAL PLUG PACK100
101614 | STEEL NAIL 1" HJZ PACK100
101615 | STEEL NAIL 11/2" HJZ PACK100
101619 | WASHER GI 10MM
101620 | WASHER GI 12MM
101627 | WASHER GI 6MM
101628 | WASHER GI 8MM
102537 | CABLE TIES CV150 PACK100
102538 | CABLE TIES CV200 PACK100
102539 | CABLE TIES CV250 PACK100
102828 | LOCK NUT 11/2" CONDUIT
102887 | WIRE CONNECTOR 15A
102907 | SOCKET GI 1" CONDUIT
102908 | SOCKET GI 11/2" CONDUIT
102910 | SOCKET GI 3/4" CONDUIT
102933 | JUNCTION BOX 2WAY ANGLE GI 3/4" CONDUIT
102940 | [NAME] FOR 2WAY GI 50MM COND
102961 | SADDLE BAR GI 1" CONDUIT
102963 | SADDLE BAR GI 11/2" CONDUIT
102967 | SADDLE BAR GI 3/4" CONDUIT
103061 | PLUG ELECT 15A ROUND PIN
103630 | FLEXIBLE DUCT INSULATED 6" R25FT
103631 | FLEXIBLE DUCT INSULATED 8"
103924 | TROLLEY WHEELS MOVABLE 160/40-80/
104572 | P-TRAP COPPER 11/8"
104575 | P-TRAP COPPER 3/4"
104576 | P-TRAP COPPER 7/8"
104743 | NIPPLE GI 3/4" SHORT
104744 | NIPPLE GI 3/4"  LONG 6"
104802 | TEE GI 3/4"
104838 | UNION GI 3/4"
105443 | PIPE GI 1" CONDUIT
105445 | PIPE GI 11/2" CONDUIT
105451 | PIPE GI 3/4" CONDUIT
105459 | PIPE GI 3/4" ERW
105523 | PUTTY 200GRM IVORY
105524 | PVC PLASTIC BAG  95X153CMX50MICRONS
105564 | PIPE PVC 75MM SEWAGE DRAIN
105578 | HOSE PVC 1" HIFLEX CONDUIT
105580 | HOSE PVC 11/2" HIFLEX CONDUIT
105585 | HOSE PVC 3/4" HIFLEX CONDUIT
105681 | [NAME]  ST 100KG W/ACC HER
105682 | [NAME]  XL 100KG W/ACC HER
105695 | PLATE MS 100X100X2.5
105770 | VIB PAD 4x4x1" CORK & RIBBED NEOPRENE
105771 | VIB PAD 4x4x2" CORK & RIBBED NEOPRENE
105775 | WING SEAL ALUM 1/2X0.032"
105776 | WOOD 8X1"X13'
105969 | MASKING TAPE 1" PAPER
105970 | MASKING TAPE 2" PAPER
105971 | MASKING TAPE 2" TRANSPERANT
105981 | SS ROUND ROD 10MM DIA
106142 | PRIMER RED OXIDE
106144 | THINNER
106151 | [NAME] 1/2X1/2" WIDTH0.91M LENGTH25M
106154 | U CHANNEL MS 3" X4MMX6M
109893 | P-TRAP COPPER K-TYPE 7/8"
110424 | STEEL NAIL 11/4" HJZ PACK100
110425 | SELF-TAP PHI SCREW FLAT 10X11/2" PAC250
110431 | PLASTIC FISHER NO F6 X30MM PACK100 MEA
113062 | SPRAY PAINT RED
113977 | GUN NAIL 2"X0.115 mm JET TECH TAIWAN
114299 | P-TRAP COPPER K-TYPE 11/8"
116015 | PLASTIC FISHER 8MM PACK50
117841 | SCREW GI 1/2"  2BA FLAT SLOT COUNTERSUNK
118226 | CUTTING DISC 4.5MM WALL
118238 | DRILL BIT MS 6MM
118241 | DRILL BIT MS 6.5MM
118242 | DRILL BIT 6MM HIL
400751 | VARNISH ULTIMEG 2000-3720E FOR MOTOR
401126 | THERMOSTAT SC2000 1S DIGI
401127 | THERMOSTAT SC2001 2S DIGI
402055 | INSULATION WINDING PAPER  0.25MM
402058 | INSULATION WINDING PAPER BLK 0.20MM
402059 | INSULATION WINDING PAPER 0.20MM
402060 | INSULATION WINDING PAPER 0.25MM NRM
402924 | SIGHT GLASS 5/8" FLARE (T)
402925 | SIGHT GLASS 3/8"
402935 | SILICON WIRE SLEEVE 14MM
404543 | MCB 6A
406189 | HOSE FLEXIBLE 1/2"X50M DRAIN
406350 | FLUX POWDER
408928 | THERMOSTAT ILUS20STK-0 1S DIGI
408929 | THERMOSTAT ILUS20MTK-1 2S DIGI
410207 | THERMOSTAT ILUS900STK-0 1S DIGI YAAS
410215 | THERMOSTAT ILUS900STK-0 1S DIGI ALS&YAAS
410500 | THERMOSTAT ILUS900MTK-0 2S DIGI HTC&YAAS
410502 | THERMOSTAT ILUS900MTK-0 2S DIGI YAAS
900009 | HALF COAT
900010 | LEATHER APRON
900012 | PAINTING MASK W/FILTER
900014 | PLASTIC NYLON ROLL 50MICRON
900015 | SAFETY BELT
900016 | SAFETY GOGGLE FOR GRINDING
900017 | SAFETY GOGGLE PLASTIC
900018 | SAFETY HELMET
900019 | SAFETY SHOES FOR COMMON LABOUR
900020 | TROUSER JEANS BLUE
900021 | WATER JUG 2 GALLON
900025 | WELDING GLASS WHITE
900026 | WELDING GLOVES
900028 | WORKER GLOVES
900057 | HOLE SAW CUTTER 20MM
900058 | HOLE SAW CUTTER 25MM
900060 | HOLE SAW CUTTER 38MM
900062 | HOLE SAW CUTTER 50MM
900123 | HACKSAW BLADE ULTRA 24T
900232 | PENCIL RED CLR 778R LYRA PACK12
900459 | DRILL BIT 12X200 HILTI
901368 | WATER JUG 3.5 GALLON
901914 | CUTTING DISC METAL 4.5"X3MM