Spreadsheet: 172904d1344365715-looking-up-values-lookup
Sheet: Sheet2

MATERIALCODE# | REC'D DATE | PRICE/LBS.
300025 | 2012-04-09 00:00:00 | 0
300001 | 2012-04-04 00:00:00 | 1.01
300071 | 2012-04-05 00:00:00 | 1.69
300089 | 2012-04-04 00:00:00 | 1.26
300202 | 2012-05-02 00:00:00 | 2.25
300001 | 2012-04-06 00:00:00 | 1.01
300112 | 2012-04-23 00:00:00 | 0.84
300067 | 2012-04-26 00:00:00 | 0.835
300067 | 2012-04-26 00:00:00 | 0.835
300097 | 2012-04-16 00:00:00 | 1.13
300104 | 2012-04-12 00:00:00 | 1.82
300104 | 2012-04-13 00:00:00 | 1.82
300114 | 2012-05-22 00:00:00 | 0.81
300141 | 2012-05-10 00:00:00 | 0.9
300237 | 2012-05-02 00:00:00 | 0.84
300067 | 2012-05-14 00:00:00 | 0.835
300089 | 2012-04-06 00:00:00 | 1.26
300111 | 2012-05-04 00:00:00 | 0.83
300142 | 2012-05-04 00:00:00 | 0.92
300141 | 2012-04-27 00:00:00 | 0.9
300152 | 2012-05-09 00:00:00 | 0.93
300237 | 2012-04-30 00:00:00 | 0.84
300023 | 2012-05-09 00:00:00 | 0.74
300030 | 2012-04-12 00:00:00 | 2.88
300059 | 2012-04-20 00:00:00 | 0.85
300066 | 2012-04-23 00:00:00 | 0.85
300066 | 2012-04-30 00:00:00 | 0.85
300066 | 2012-05-09 00:00:00 | 0.85
300128 | 2012-04-09 00:00:00 | 4.83
300078 | 2012-04-24 00:00:00 | 1.25
300131 | 2012-04-23 00:00:00 | 3.56
300274 | 2012-04-13 00:00:00 | 1.21
300086 | 2012-04-11 00:00:00 | 1.27
300104 | 2012-04-11 00:00:00 | 1.82
300005 | 2012-04-13 00:00:00 | 0.97
300182 | 2012-04-20 00:00:00 | 4.62
300099 | 2012-04-10 00:00:00 | 2.165
300181 | 2012-04-20 00:00:00 | 5.04
300100 | 2012-04-24 00:00:00 | 1.93
300174 | 2012-04-19 00:00:00 | 2.02
300219 | 2012-04-23 00:00:00 | 4.155
300206 | 2012-04-19 00:00:00 | 0.845
300131 | 2012-04-14 00:00:00 | 3.25
300131 | 2012-04-13 00:00:00 | 3.25
300089 | 2012-04-12 00:00:00 | 1.26
300103 | 2012-04-11 00:00:00 | 1.925
300142 | 2012-04-14 00:00:00 | 0.92
300142 | 2012-04-15 00:00:00 | 0.92
300174 | 2012-04-23 00:00:00 | 2.02
300067 | 2012-04-26 00:00:00 | 0.835
300194 | 2012-04-23 00:00:00 | 1.32
300100 | 2012-04-12 00:00:00 | 2.165
300142 | 2012-04-18 00:00:00 | 0.92
300142 | 2012-04-19 00:00:00 | 0.92
300002 | 2012-04-17 00:00:00 | 1.04
300001 | 2012-04-18 00:00:00 | 1.01
300071 | 2012-04-18 00:00:00 | 1.75
300071 | 2012-04-23 00:00:00 | 1.75
300088 | 2012-04-18 00:00:00 | 1.32
300022 | 2012-05-04 00:00:00 | 0.71
300067 | 2012-05-04 00:00:00 | 0.835
300035 | 2012-04-26 00:00:00 | 0.855
300030 | 2012-04-20 00:00:00 | 2.88
300037 | 2012-04-20 00:00:00 | 2.88
300006 | 2012-04-17 00:00:00 | 1.045
300132 | 2012-04-20 00:00:00 | 3.17
300132 | 2012-04-19 00:00:00 | 3.17
300221 | 2012-04-30 00:00:00 | 7.5
300130 | 2012-04-23 00:00:00 | 3.56
300219 | 2012-04-30 00:00:00 | 3.4
300032 | 2012-04-23 00:00:00 | 0.9
300123 | 2012-04-20 00:00:00 | 3.61
300152 | 2012-05-17 00:00:00 | 0.93
300026 | 2012-04-23 00:00:00 | 0.72
300026 | 2012-04-23 00:00:00 | 0.72
300212 | 2012-05-14 00:00:00 | 0.7508
300001 | 2012-04-24 00:00:00 | 1.01
300038 | 2012-04-24 00:00:00 | 5.96
300028 | 2012-05-22 00:00:00 | 0.72
300028 | 2012-05-24 00:00:00 | 0.72
300028 | 2012-05-25 00:00:00 | 0.72
300028 | 2012-05-31 00:00:00 | 0.72
300028 | 2012-06-20 00:00:00 | 0.72
300248 | 2012-05-18 00:00:00 | 2.09
300071 | 2012-04-24 00:00:00 | 1.75
300121 | 2012-05-07 00:00:00 | 3.15
300201 | 2012-05-03 00:00:00 | 2.25
300231 | 2012-05-08 00:00:00 | 0.83
300275 | 2012-04-25 00:00:00
300023 | 2012-05-01 00:00:00 | 0.81
300023 | 2012-04-26 00:00:00 | 0.81
300023 | 2012-04-27 00:00:00 | 0.81
300276 | 2012-04-24 00:00:00
300277 | 2012-04-24 00:00:00
300088 | 2012-04-24 00:00:00 | 1.32
300278 | 2012-04-24 00:00:00
300062 | 2012-04-30 00:00:00 | 2.765
300023 | 2012-05-02 00:00:00 | 0.81
300131 | 2012-05-07 00:00:00 | 2.11
300212 | 2012-05-03 00:00:00 | 0.8435
300232 | 2012-05-03 00:00:00 | 0.8
300077 | 2012-05-04 00:00:00 | 1.25
300077 | 2012-05-07 00:00:00 | 1.25
300001 | 2012-05-04 00:00:00 | 1.01
300149 | 2012-05-07 00:00:00 | 2.28
300088 | 2012-05-04 00:00:00 | 1.32
300102 | 2012-05-04 00:00:00 | 1.925
300001 | 2012-05-04 00:00:00 | 1.01
300071 | 2012-05-04 00:00:00 | 1.75
300088 | 2012-05-04 00:00:00 | 1.32
300131 | 2012-05-09 00:00:00 | 2.11
300167 | 2012-05-14 00:00:00 | 1.55
300182 | 2012-05-14 00:00:00 | 1.18
300067 | 2012-05-17 00:00:00 | 0.765
300067 | 2012-06-01 00:00:00 | 0.765
300067 | 2012-06-18 00:00:00 | 0.765
300111 | 2012-06-07 00:00:00 | 0.77
300236 | 2012-05-22 00:00:00 | 0.77
300236 | 2012-06-07 00:00:00 | 0.77
300140 | 2012-05-28 00:00:00 | 0.83
300140 | 2012-06-13 00:00:00 | 0.83
300212 | 2012-06-01 00:00:00 | 0.7508
300151 | 2012-06-07 00:00:00 | 0.86
300240 | 2012-05-25 00:00:00 | 0.83
300059 | 2012-06-03 00:00:00 | 0.77
300067 | 2012-06-05 00:00:00 | 0.765
300066 | 2012-05-22 00:00:00 | 0.78
300066 | 2012-05-25 00:00:00 | 0.78
300066 | 2012-06-08 00:00:00 | 0.78
300085 | 2012-05-14 00:00:00 | 1.21
300012 | 2012-05-15 00:00:00 | 1.77
300062 | 2012-05-14 00:00:00 | 2.59
300127 | 2012-05-15 00:00:00 | 4.83
300279 | 2012-06-08 00:00:00 | 2.17
300001 | 2012-05-16 00:00:00 | 1.01
300035 | 2012-05-17 00:00:00 | 0.785
300096 | 2012-05-21 00:00:00 | 1.06
300071 | 2012-05-16 00:00:00 | 1.75
300088 | 2012-05-16 00:00:00 | 1.32
300103 | 2012-05-16 00:00:00 | 1.91
300102 | 2012-05-16 00:00:00 | 1.925
300236 | 2012-05-18 00:00:00 | 0
300021 | 2012-05-23 00:00:00 | 0.695
300232 | 2012-05-17 00:00:00 | 0.84
300201 | 2012-06-04 00:00:00 | 2.25
300001 | 2012-05-18 00:00:00 | 1.01
300071 | 2012-05-18 00:00:00 | 1.75
300066 | 2012-05-19 00:00:00 | 0.81
300066 | 2012-05-21 00:00:00 | 0.81
300193 | 2012-05-23 00:00:00 | 1.28
300240 | 2012-05-23 00:00:00 | 0.86
300177 | 2012-05-31 00:00:00 | 4.05
300246 | 2012-05-24 00:00:00 | 1.89
300175 | 2012-05-31 00:00:00 | 1.58
300175 | 2012-06-01 00:00:00 | 1.58
300102 | 2012-05-24 00:00:00 | 1.925
300103 | 2012-05-24 00:00:00 | 1.91
300103 | 2012-05-25 00:00:00 | 1.91
300026 | 2012-05-31 00:00:00 | 0.65
300026 | 2012-06-01 00:00:00 | 0.65
300066 | CANCELLED | CANCELLED
300110 | 2012-06-06 00:00:00 | 0.76
300110 | 2012-06-14 00:00:00 | 0.69
300140 | 2012-06-14 00:00:00 | 0.76
300236 | 2012-06-14 00:00:00 | 0.7
300001 | 2012-05-25 00:00:00 | 1.01
300194 |  | 1.87
300023 | 2012-06-08 00:00:00 | 0.67
300175 |  | 1.58
300218 | 2012-06-06 00:00:00 | 4.145
300077 | 2012-05-27 00:00:00 | 1.25
300035 | 2012-05-30 00:00:00 | 0.785
300103 | 2012-06-01 00:00:00 | 1.91
300103 | 2012-06-04 00:00:00 | 1.91
300103 | 2012-05-30 00:00:00 | 1.91
300067 | 2012-05-29 00:00:00 | 0.765
300067 | 2012-05-29 00:00:00 | 0.765
300067 | 2012-05-26 00:00:00 | 0.765
300067 | 2012-05-26 00:00:00 | 0.765
300077 | 2012-06-21 00:00:00 | 1.25
300071 | 2012-05-25 00:00:00 | 1.75
300088 | 2012-05-25 00:00:00 | 1.32
300077 | 2012-06-02 00:00:00 | 1.25
300133 | 2012-05-31 00:00:00 | 2.06
300133 | 2012-05-31 00:00:00 | 2.06
300193 | 2012-05-31 00:00:00 | 1.28
300110 | 2012-06-02 00:00:00 | 0.69
300111 | 2012-05-31 00:00:00 | 0.77
300113 | 2012-06-05 00:00:00 | 0.74
300032 | 2012-06-11 00:00:00 | 0.83
300076 | 2012-06-02 00:00:00 | 1.445
300076 | 2012-06-05 00:00:00 | 1.445
300201 | 2012-06-15 00:00:00 | 2.25
300001 | 2012-06-01 00:00:00 | 0.98
300088 | 2012-06-01 00:00:00 | 1.25
300071 | 2012-06-01 00:00:00 | 1.68
300059 | CANCELLED | CANCELLED
300066 | 2012-06-15 00:00:00 | 0.71
300066 | 2012-06-18 00:00:00 | 0.71
300066 | 2012-06-25 00:00:00 | 0.71
300066 | 2012-06-25 00:00:00 | 0.71
300158 | 2012-06-15 00:00:00 | 0.72
300066 | 2012-06-06 00:00:00 | 0.775
300066 | 2012-06-08 00:00:00 | 0.775
300236 | 2012-07-06 00:00:00 | 0.7
300023 | CANCELLED | CANCELLED
300023 | CANCELLED | CANCELLED
300140 | 2012-07-05 00:00:00 | 0.76
300141 | CANCELLED | CANCELLED
300110 | 2012-06-29 00:00:00 | 0.69
300059 | 2012-06-20 00:00:00 | 0.71
300067 | 2012-07-05 00:00:00 | 0.695
300077 | 2012-05-25 00:00:00 | 1.25
300032 | 2012-05-31 00:00:00 | 0.84
300032 | 2012-06-01 00:00:00 | 0.84
300030 | 2012-06-07 00:00:00 | 2.88
300030 | 2012-06-12 00:00:00 | 2.88
300001 | 2012-06-04 00:00:00 | 0.98
300071 | 2012-06-04 00:00:00 | 1.68
300088 | 2012-06-04 00:00:00 | 1.25
300221 | 2012-06-04 00:00:00 | 7.5
300221 | 2012-06-07 00:00:00 | 7.5
300161 | 2012-06-13 00:00:00 | 0.69
300121 | 2012-06-19 00:00:00 | 3.11
300113 | 2012-07-09 00:00:00 | 0.67
300236 | 2012-06-28 00:00:00 | 0.7
300236 | 2012-07-13 00:00:00 | 0.7
300140 | 2012-06-28 00:00:00 | 0.76
300141 |  | 0.78
300067 | 2012-06-21 00:00:00 | 0.695
300067 | 2012-07-03 00:00:00 | 0.695
300067 | 2012-07-19 00:00:00 | 0.695
300059 | 2012-06-21 00:00:00 | 0.71
300161 | 2012-06-27 00:00:00 | 0.69
300193 | 2012-06-16 00:00:00 | 1.28
300118 | 2012-06-25 00:00:00 | 0.78
300118 | 2012-07-05 00:00:00 | 0.78
300019 | 2012-06-14 00:00:00 | 1.34
300132 | 2012-06-14 00:00:00 | 3.12
300019 | 2012-06-13 00:00:00 | 1.34
300085 | 2012-06-19 00:00:00 | 1.21
300001 | 2012-06-13 00:00:00 | 0.98
300088 | 2012-06-13 00:00:00 | 1.25
300071 | 2012-06-13 00:00:00 | 1.68
300201 | 2012-07-03 00:00:00 | 2.25
300193 | 2012-07-12 00:00:00 | 1.28
300096 | 2012-06-18 00:00:00 | 0.85
300026 | 2012-06-19 00:00:00 | 0.58
300026 | 2012-06-15 00:00:00 | 0.58
300025 | 2012-07-03 00:00:00 | 0.58
300025 | 2012-06-28 00:00:00 | 0.58
300096 | 2012-06-19 00:00:00 | 0.92
300096 | 2012-06-20 00:00:00 | 0.92
300088 | 2012-06-15 00:00:00 | 1.25
300026 | 2012-06-20 00:00:00 | 0.58
300232 | 2012-06-20 00:00:00 | 0.715
300116 | 2012-06-27 00:00:00 | 3.92
300026 | 2012-06-22 00:00:00 | 0.58
300221 | 2012-06-22 00:00:00 | 7.46
300205 | 2012-07-03 00:00:00 | 0.705
300212 | 2012-07-09 00:00:00 | 0.7508
300001 | 2012-06-22 00:00:00 | 0.98
300071 | 2012-06-22 00:00:00 | 1.68
300249 | 2012-06-19 00:00:00 | 0.3538
300001 | 2012-06-25 00:00:00 | 0.98
300228 | 2012-07-17 00:00:00
300103 | 2012-06-28 00:00:00 | 1.89
300103 | 2012-06-19 00:00:00 | 0
300103 | 2012-06-19 00:00:00 | 1.91
300103 | 2012-06-19 00:00:00 | 0
300161 | 2012-06-29 00:00:00 | 0.69
300161 | 2012-06-27 00:00:00 | 0.69
300280 | 2012-07-16 00:00:00
300281 |  | 0.7
300001 | 2012-06-28 00:00:00 | 0.98
300005 | 2012-06-28 00:00:00 | 0.965
300175 | 2012-07-12 00:00:00 | 1.58
300175 |  | 1.58
300088 | 2012-06-28 00:00:00 | 1.25
300088 | 2012-06-29 00:00:00 | 1.25
300132 | 2012-07-05 00:00:00 | 3.12
300077 | 2012-07-05 00:00:00 | 1.25
300217 |  | 3.42
300130 | 2012-07-06 00:00:00 | 3.52
300236 |  | 0.7
300236 |  | 0.7
300111 |  | 0.7
300113 |  | 0.67
300140 |  | 0.76
300067 |  | 0.695
300067 |  | 0.695
300059 |  | 0.71
300025 |  | 0.6
300282
300001 | 2012-07-06 00:00:00 | 0.98
300071 | 2012-07-06 00:00:00 | 1.61
300088 | 2012-07-06 00:00:00 | 1.18
300283 | CANCELLED | CANCELLED
300284 | 2012-07-10 00:00:00
300285 | 2012-07-10 00:00:00
300102 | 2012-07-05 00:00:00 | 1.885
300161 | 2012-07-11 00:00:00 | 0.69
300076 | 2012-07-16 00:00:00 | 1.445
300080 | 2012-07-16 00:00:00
300077 | 2012-07-16 00:00:00 | 1.25
300066 |  | 0.71
300066 |  | 0.71
300066 |  | 0.71
300067 |  | 0.695
300059 |  | 0.71
300140 |  | 0.76
300140 |  | 0.76
300110 |  | 0.69
300110 |  | 0.69
300035 | 2012-07-15 00:00:00 | 0.78
300132 | 2012-07-16 00:00:00 | 3.12
300025 |  | 0.6
300240 |  | 0.76
300220 | 2012-07-20 00:00:00
300286 | 2012-07-18 00:00:00
300035 | 2012-07-13 00:00:00 | 0.715
300102 | 2012-07-11 00:00:00 | 1.885
300102 |  | 1.885
300161 | 2012-07-18 00:00:00 | 0.69
300121 |  | 3.07
300001 | 2012-07-13 00:00:00 | 0.98
300001 | 2012-07-13 00:00:00 | 0.98
300088 |  | 1.18
300023 | 2012-07-16 00:00:00 | 0.6
300097 |  | 0.935
 | 2012-07-06 00:00:00 | N/C
 | 2012-07-12 00:00:00 | N/C
 | 2012-07-12 00:00:00 | N/C
300077 |  | 1.25
300201 |  | 2.25
300118 |  | 0.78
300212 | 2012-07-21 00:00:00 | 0.705
300212 |  | 0.705
300038 |  | 6.08
300026 |  | 0.6
300085 |  | 1.21
300066 |  | 0.71
300025 | CANCELLED | CANCELLED
300236 |  | 0.7
300035 |  | 0.72
40000
[NAME]
[NAME] | cancelled | cancelled
[NAME]
B.T.