Spreadsheet: 37995d1236105507-vlookup-data-based-on-2-condition2-vlookup-
Sheet: Sheet2

Starting Date | Ending Date | Item No. | Direct Unit Cost
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 35683 | 247
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 35684 | 384
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 35818 | 57
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 35819 | 27.5
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37690 | 374
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37691 | 273
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37692 | 273
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37693 | 155
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37694 | 18.4
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37695 | 31
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37696 | 14
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 37697 | 23
2000-01-01 00:00:00 | 2007-01-31 00:00:00 | 39627 | 208
2000-01-01 00:00:00 |  | 45161 | 342
2000-01-01 00:00:00 |  | 45162 | 392
2000-01-01 00:00:00 |  | 45163 | 329
2000-01-01 00:00:00 |  | 45164 | 265
2000-01-01 00:00:00 |  | 45165 | 330
2000-01-01 00:00:00 |  | 45166 | 195
2000-01-01 00:00:00 |  | 45167 | 131
2000-01-01 00:00:00 |  | 45168 | 166
2000-01-01 00:00:00 |  | 45169 | 17
2000-01-01 00:00:00 |  | 45170 | 54
2000-01-01 00:00:00 |  | 45171 | 54
2000-01-01 00:00:00 |  | 45172 | 166
2000-01-01 00:00:00 |  | 45173 | 34.3
2000-01-01 00:00:00 |  | 45174 | 16
2000-01-01 00:00:00 |  | 45175 | 42.5
2000-01-01 00:00:00 |  | 45176 | 23
2000-01-01 00:00:00 |  | 45990 | 112
2000-01-01 00:00:00 |  | 49702 | 440.5
2000-01-01 00:00:00 |  | 49703 | 362
2000-01-01 00:00:00 |  | 49704 | 256
2000-01-01 00:00:00 |  | 49705 | 126
2000-01-01 00:00:00 |  | 53470 | 158.5
2000-01-01 00:00:00 |  | 53471 | 286
2000-01-01 00:00:00 |  | 53472 | 103
2000-01-01 00:00:00 |  | 53473 | 279
2000-01-01 00:00:00 |  | 56818 | 18
2000-01-01 00:00:00 |  | 56819 | 31
2000-01-01 00:00:00 |  | 56820 | 124
2000-01-01 00:00:00 |  | 60574 | 171
2000-01-01 00:00:00 |  | 60575 | 291
2000-01-01 00:00:00 |  | 60577 | 338
2000-01-01 00:00:00 |  | 60578 | 422
2005-08-30 00:00:00 |  | 65179 | 318
2005-08-30 00:00:00 |  | 65180 | 360
2005-08-30 00:00:00 |  | 65181 | 430
2007-03-11 00:00:00 |  | 80328 | 249
2007-03-11 00:00:00 |  | 80329 | 390
2007-03-11 00:00:00 |  | 80330 | 299
2007-03-11 00:00:00 |  | 80331 | 188
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80804 | 11.5
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80804 | 10.5
2008-02-25 00:00:00 |  | 80804 | 8.5
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80805 | 15.75
2007-07-05 00:00:00 | 2008-06-24 00:00:00 | 80805 | 14.25
2008-06-25 00:00:00 |  | 80805 | 6
2007-03-20 00:00:00 | 2008-02-24 00:00:00 | 80806 | 29
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 80806 | 12.68
2008-06-25 00:00:00 | 2008-07-28 00:00:00 | 80806 | 9.75
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 80806 | 9.5
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 80806 | 8.75
2008-11-12 00:00:00 | 2009-01-25 00:00:00 | 80806 | 6.25
2009-01-26 00:00:00 |  | 80806 | 6
2007-03-20 00:00:00 | 2007-08-18 00:00:00 | 80807 | 65
2007-08-19 00:00:00 | 2008-02-24 00:00:00 | 80807 | 47.5
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 80807 | 28
2008-06-25 00:00:00 | 2008-07-28 00:00:00 | 80807 | 18
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 80807 | 16.75
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 80807 | 14.5
2008-11-12 00:00:00 | 2009-01-25 00:00:00 | 80807 | 11.25
2009-01-26 00:00:00 |  | 80807 | 9.9
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80808 | 15.5
2007-07-05 00:00:00 |  | 80808 | 14.5
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80809 | 30
2007-07-05 00:00:00 |  | 80809 | 25
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80810 | 9.75
2007-07-05 00:00:00 | 2007-10-02 00:00:00 | 80810 | 9.25
2007-10-03 00:00:00 |  | 80810 | 11.75
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80811 | 17
2007-07-05 00:00:00 | 2008-06-24 00:00:00 | 80811 | 16
2008-06-25 00:00:00 | 2008-07-28 00:00:00 | 80811 | 6.5
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 80811 | 5.8
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 80811 | 4.9
2008-11-12 00:00:00 |  | 80811 | 3.75
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80812 | 19
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80812 | 16
2008-02-25 00:00:00 |  | 80812 | 13
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80813 | 40
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80813 | 32
2008-02-25 00:00:00 |  | 80813 | 31
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80815 | 15
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80815 | 13.75
2008-02-25 00:00:00 |  | 80815 | 11.5
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80905 | 28
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80905 | 26
2008-02-25 00:00:00 |  | 80905 | 16
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80906 | 12
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80906 | 10.5
2008-02-25 00:00:00 |  | 80906 | 8
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80907 | 18
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80907 | 15.5
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 80907 | 12
2008-06-25 00:00:00 |  | 80907 | 9
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80908 | 32
2007-07-05 00:00:00 | 2008-02-24 00:00:00 | 80908 | 25
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 80908 | 20
2008-06-25 00:00:00 | 2008-07-28 00:00:00 | 80908 | 11
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 80908 | 10.75
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 80908 | 9.5
2008-11-12 00:00:00 |  | 80908 | 6.9
2007-03-20 00:00:00 | 2007-07-04 00:00:00 | 80909 | 45
2007-07-05 00:00:00 | 2007-10-02 00:00:00 | 80909 | 40
2007-10-03 00:00:00 | 2008-02-24 00:00:00 | 80909 | 45
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 80909 | 33
2008-06-25 00:00:00 | 2008-07-28 00:00:00 | 80909 | 19
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 80909 | 18.5
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 80909 | 15.75
2008-11-12 00:00:00 |  | 80909 | 11.5
2007-08-13 00:00:00 | 2008-02-24 00:00:00 | 84936 | 36.5
2008-02-25 00:00:00 | 2008-07-28 00:00:00 | 84936 | 18
2008-07-29 00:00:00 | 2008-08-31 00:00:00 | 84936 | 10
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 84936 | 9
2008-11-12 00:00:00 | 2009-01-25 00:00:00 | 84936 | 7
2009-01-26 00:00:00 |  | 84936 | 6.5
2007-09-26 00:00:00 | 2008-02-24 00:00:00 | 86749 | 94
2008-02-25 00:00:00 | 2008-06-24 00:00:00 | 86749 | 60
2008-06-25 00:00:00 | 2008-08-31 00:00:00 | 86749 | 40
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 86749 | 31
2008-11-12 00:00:00 | 2009-01-25 00:00:00 | 86749 | 20.75
2009-01-26 00:00:00 |  | 86749 | 19
2008-06-18 00:00:00 | 2008-08-31 00:00:00 | 94717 | 88
2008-09-01 00:00:00 | 2009-01-25 00:00:00 | 94717 | 60
2009-01-26 00:00:00 |  | 94717 | 42
2008-06-18 00:00:00 | 2008-08-31 00:00:00 | 94719 | 39.5
2008-09-01 00:00:00 | 2008-11-11 00:00:00 | 94719 | 32
2008-11-12 00:00:00 |  | 94719 | 21