Spreadsheet: 115570d1311145326-vlookup-or-match-help-working
Sheet: 30-6-2011 invt

code | Inventory as on 30-6-2011
0009 | 1258.004
0013 | 1366.02
0017 | 21772.003
0018 | 1262.011
0022 | 68.008
0030 | 2005.003
0032 | 445.008
0034 | 2827.008
0035 | 150.008
0037 | 643.005
0038 | 661.02
0039 | 44.022
0040 | 43.022
0043 | 1180.005
0044 | 1209.008
0046 | 12.009
0049 | 2900.013
0050 | 1098.007
0063 | 9.02
0066 | 82.015
0075 | 1289.002
0086 | 122
0089 | 260
0090 | 199.02
0096 | 571.002
0102 | 2.01
0112 | 1
0115 | 35.005
0116 | 11.007
0120 | 171.004
0121 | 1481.001
0122 | 1392.011
0123 | 752
0126 | 135
0129 | 100
0217 | 0.011
0218 | 0.003
0226 | 11.004
0228 | 10.001
0239 | 3
0246 | 0.006
0261 | 0
0263 | 4.001
0286 | 5.004
0290 | 0.002
0311 | 2
0313 | 26.001
0315 | 23.001
0318 | 35.001
0321 | 0.001
0325 | 58
0326 | 4.173
0332 | 10.001
0337 | 7.008
0338 | 11.001
0339 | 6.002
0341 | 0.008
0349 | 1
0351 | 3
0352 | 2.001
0353 | 5
0354 | 4.004
0355 | 3
0356 | 4.005
0360 | 5
0361 | 4
0363 | 24.003
0364 | 24.004
0367 | 3
0368 | 2
0374 | 0.013
0375 | 20.007
0378 | 24
0401 | 0.008
0404 | 10.173
0421 | 7.005
0439 | 70
0441 | 483.005
0442 | 25.022
0443 | 32.012
0444 | 5.118
0445 | 83.007
0455 | 31.005
0457 | 400.009
0461 | 0.002
0480 | 118.002
0491 | 48
0495 | 4.001
0498 | 28
0521 | 11617.005
0522 | 12436.008
0531 | 2594.009
0533 | 1561.005
0534 | 1718.038
0545 | 1363.002
0581 | 223
0600 | 58.009
0621 | 5.006
0701 | 3.01
0702 | 51
0721 | 489.004
0723 | 442.021
0811 | 935.001
0813 | 18.004
0814 | 19.004
0815 | 5.073
0816 | 19
0817 | 20.004
0820 | 965
0825 | 32.003
0850 | 27.004
0851 | 3931.01
0852 | 604.005
0853 | 9.002
0854 | 0.059
0858 | 32
0859 | 68
0861 | 383.009
0862 | 36.01
0863 | 20.003
0864 | 24.009
0901 | 4140
0903 | 1547.021
1004 | 0.009
1006 | 29.006
1021 | 265.007
1022 | 1320.005
1025 | 52
1026 | 67.005
1027 | 40.009
1050 | 5.006
1101 | 14
1103 | 25.011
1112 | 28.005
1150 | 146.005
1151 | 99.011
1159 | 0.001
1161 | 3
1163 | 6.003
1164 | 15.002
1168 | 19.004
1169 | 11.002
1176 | 177.006
1177 | 81.008
1179 | 8.001
1201 | 56.003
1205 | 35.006
1206 | 8.011
1241 | 49.006
1324 | 1000
1325 | 213.019
1326 | 338.007
1401 | 68
1402 | 34.022
1421 | 12.008
1422 | 78
1423 | 113.003
1451 | 17.005
1452 | 4.001
1456 | 5.003
1457 | 14.001
1504 | 19.005
1506 | 4.004
1508 | 14.005
1509 | 19.001
1510 | 20.001
1512 | 44.001
1513 | 18.004
1515 | 251.004
1516 | 4.005
1517 | 8.003
1518 | 20.003
1520 | 148
1521 | 7
1529 | 55.005
1532 | 4.005
1535 | 0.005
1537 | 18.002
1538 | 0.002
1541 | 7.005
1558 | 63.001
1559 | 40.001
1562 | 27.003
1563 | 100
1564 | 31.003
1573 | 803.005
1580 | 1
1593 | 1.004
1594 | 0.008
1595 | 1.008
1596 | 2.005
1597 | 2.005
1601 | 17.002
1602 | 2.002
1611 | 8
1612 | 0.002
1621 | 38
1622 | 70.007
1623 | 14.015
1625 | 0.001
1626 | 37
1631 | 33.002
1632 | 13.001
1636 | 6.002
1641 | 0.003
1643 | 1.003
1655 | 66.002
1701 | 172.009
1702 | 153
1703 | 76.006
1706 | 17.002
1709 | 17.022
1710 | 12.018
1730 | 22.006
1731 | 38.008
1732 | 39.011
1737 | 118.011
1748 | 36.001
1751 | 11.01
1754 | 44.009
1757 | 19.005
1759 | 14.01
1779 | 18.003
1783 | 69.007
1784 | 16.003
1785 | 22.006
1790 | 40.01
1791 | 101.001
1792 | 17.022
1803 | 14.004
1814 | 29.008
1815 | 0.002
1816 | 36.003
1818 | 16.002
1820 | 79.008
1821 | 77.006
1822 | 58.006
1823 | 59.001
1824 | 23.01
1825 | 118.005
1826 | 79.004
1827 | 29.003
1828 | 77.009
1829 | 58.003
1830 | 8
1831 | 2
1832 | 3
1833 | 13
1834 | 3
1835 | 13
1838 | 2
1839 | 2
1852 | 0
1858 | 53.002
1861 | 34.002
1863 | 267.001
1864 | 232.005
1865 | 571.004
1866 | 99.004
1867 | 87.004
1868 | 125.001
1869 | 77.005
1871 | 179.001
1872 | 194
1882 | 37.001
1883 | 99.01
1884 | 99.008
1885 | 149.006
1886 | 149.004
1887 | 124.004
1888 | 29.01
1899 | 3.009
1901 | 10.006
1902 | 338.007
1906 | 65.004
1907 | 4.002
1918 | 67.01
1919 | 77.01
1920 | 68.003
1921 | 52.011
1931 | 20.006
1935 | 17.006
1939 | 15
1940 | 119.001
1942 | 675.001
1946 | 231.005
1949 | 185.002
1958 | 35.009
1959 | 305.008
1962 | 0
1964 | 123.006
1967 | 8.003
1970 | 5.002
1973 | 1.005
1975 | 292.01
1979 | 137.009
1980 | 47.007
1981 | 97.005
1986 | 245.005
1987 | 97
1989 | 74.005
1990 | 76
1991 | 121.011
1992 | 147
1993 | 97.005
1996 | 0.002
2000 | 452.005
2001 | 378.004
2002 | 348.002
2003 | 270.009
2013 | 269.002
2015 | 238.002
2017 | 158.001
2045 | 202.002
2047 | 54.003
2048 | 210.001
2049 | 254
2051 | 183.01
2052 | 175.011
2053 | 224.008
2054 | 145.007
2055 | 201.008
2056 | 187.002
2057 | 61.011
2058 | 87.005
2067 | 76.011
2068 | 114.007
2069 | 57.01
2070 | 16.01
2072 | 5.009
2074 | 4.003
2080 | 32.006
2081 | 81.004
2082 | 79.01
2083 | 110.01
2084 | 90.004
2085 | 100.01
2086 | 76
2093 | 29.001
2094 | 28.006
2095 | 300
2096 | 300
2097 | 200
2104 | 16.009
2109 | 2.011
2112 | 17.003
2121 | 28.005
2122 | 25.006
2210 | 77
2215 | 332.001
2216 | 945
2217 | 187.001
2218 | 233
2247 | 7.003
2252 | 525.004
2253 | 745.001
2254 | 293.002
2255 | 132
2256 | 99.001
2257 | 525.003
2258 | 494.005
2259 | 58
2260 | 9.005
2266 | 266.007
2267 | 89.011
2268 | 142.001
2269 | 139.008
2272 | 57.001
2273 | 21.002
2277 | 8.011
2278 | 14.003
2281 | 12.004
2282 | 50.002
2283 | 103.008
2284 | 38.008
2285 | 101.005
2286 | 42.004
2302 | 71.01
2305 | 30.011
2306 | 62
2307 | 13
2309 | 15.001
2411 | 214.005
2412 | 127.002
2413 | 305.003
2414 | 92
2415 | 109.004
2416 | 106.004
2420 | 37.003
2421 | 52.006
2422 | 47.004
2451 | 5
2452 | 86.003
2453 | 95.002
2454 | 83.002
2455 | 18
2456 | 37.004
2457 | 94.004
2506 | 0
2508 | 101.004
2510 | 81.002
2511 | 294.003
2515 | 360.003
2517 | 68.005
2519 | 16.004
2523 | 105.001
2531 | 13.002
2532 | 33.001
2533 | 59.008
2534 | 70.009
2535 | 17.008
2536 | 58.004
2537 | 216.006
2538 | 138.006
2539 | 0.001
2540 | 110.004
2541 | 10.003
2542 | 173.001
2543 | 182.004
2544 | 132.002
2545 | 157.004
2604 | 24.01
2605 | 48.008
2606 | 44.005
2608 | 111
2609 | 42.008
2651 | 177
2652 | 110.005
2711 | 212.003
2719 | 8.003
2722 | 5.005
2723 | 8.001
2813 | 6.006
2819 | 54.005
2820 | 35.01
2822 | 484.009
2824 | 145.001
2826 | 1725.004
2827 | 885.003
2828 | 664.001
2829 | 14.003
2830 | 37.004
3003 | 2
3005 | 2
3010 | 12
3020 | 16
3045 | 48
3060 | 5.022
3061 | 3
3062 | 7.021
3065 | 5.016
3066 | 3
3071 | 6
3074 | 3
3075 | 4
3077 | 34
3089 | 155.01
3407 | 21
3411 | 1
3428 | 13
3432 | 35
3441 | 50
3442 | 44
3443 | 115
3444 | 7
3516 | 1
3517 | 1
3519 | 1
3521 | 1
3524 | 1
5211 | 50.011
5215 | 6.023
5216 | 10.001
5219 | 6.011
5241 | 3.006
5406 | 1.005
6031 | 460
6055 | 30
6211 | 260
6221 | 59
6231 | 118.003
6251 | 79
6253 | 199
6265 | 79
6271 | 360
6281 | 59
6291 | 139.005
6293 | 0.005
6315 | 75.01
6325 | 10
6329 | 80