Spreadsheet: 139342d1328196495-vlookup-based-on-date-criteria-lookup
Sheet: 2011 Price List

Part Number | Price | Start Date | End Date
1 | 0.4 | 2011-12-27 00:00:00 | 2012-02-01 00:00:00
2 | 0.5 | 2011-12-08 00:00:00 | 2012-02-01 00:00:00
3 | 0.2362 | 2011-12-01 00:00:00 | 2012-02-01 00:00:00
4 | 0.2362 | 2011-12-01 00:00:00 | 2012-02-01 00:00:00
5 | 0.2362 | 2011-12-01 00:00:00 | 2012-02-01 00:00:00
6 | 0.2362 | 2011-12-01 00:00:00 | 2012-02-01 00:00:00
7 | 0.42 | 2011-12-01 00:00:00 | 2012-02-01 00:00:00
8 | 7.7 | 2011-10-06 00:00:00 | 2012-02-01 00:00:00
9 | 0.333 | 2011-10-01 00:00:00 | 2012-02-01 00:00:00
10 | 0.29 | 2011-10-01 00:00:00 | 2011-12-31 00:00:00
11 | 0.29 | 2011-10-01 00:00:00 | 2011-12-31 00:00:00
12 | 0.42 | 2011-09-28 00:00:00 | 2012-02-01 00:00:00
13 | 0.241 | 2011-09-02 00:00:00 | 2011-11-30 00:00:00
14 | 0.241 | 2011-09-02 00:00:00 | 2011-11-30 00:00:00
15 | 13.51 | 2011-09-01 00:00:00 | 2012-02-01 00:00:00
16 | 16.39 | 2011-09-01 00:00:00 | 2012-02-01 00:00:00
17 | 12.66 | 2011-09-01 00:00:00 | 2012-02-01 00:00:00
18 | 0.241 | 2011-09-01 00:00:00 | 2011-11-30 00:00:00
19 | 0.241 | 2011-09-01 00:00:00 | 2011-11-30 00:00:00
20 | 0.43 | 2011-07-19 00:00:00 | 2011-11-30 00:00:00
21 | 0.307 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00
22 | 0.307 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00
23 | 0.335 | 2011-07-01 00:00:00 | 2011-09-30 00:00:00
24 | 0.423 | 2011-06-28 00:00:00 | 2012-02-01 00:00:00
25 | 0.41 | 2011-06-18 00:00:00 | 2012-02-01 00:00:00
26 | 0.41 | 2011-06-18 00:00:00 | 2012-02-01 00:00:00
27 | 0.2485 | 2011-06-04 00:00:00 | 2011-09-01 00:00:00
28 | 0.2485 | 2011-06-04 00:00:00 | 2011-09-01 00:00:00
29 | 0.31 | 2011-06-02 00:00:00 | 2012-02-01 00:00:00
30 | 0.31 | 2011-06-02 00:00:00 | 2012-02-01 00:00:00
31 | 0.31 | 2011-06-02 00:00:00 | 2012-02-01 00:00:00
32 | 0.297 | 2011-06-02 00:00:00 | 2012-02-01 00:00:00
33 | 0.2485 | 2011-06-02 00:00:00 | 2011-08-31 00:00:00
34 | 0.2485 | 2011-06-02 00:00:00 | 2011-08-31 00:00:00
35 | 0.355 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
36 | 0.4 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
37 | 0.322 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
38 | 0.322 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
39 | 0.38 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
40 | 0.4 | 2011-04-21 00:00:00 | 2012-02-01 00:00:00
41 | 0.45 | 2011-04-20 00:00:00 | 2011-06-27 00:00:00
42 | 0.312 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00
43 | 0.337 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00
44 | 0.312 | 2011-04-01 00:00:00 | 2011-06-30 00:00:00
45 | 0.2536 | 2011-03-17 00:00:00 | 2011-06-03 00:00:00
46 | 0.2536 | 2011-03-17 00:00:00 | 2011-06-03 00:00:00
47 | 0.2536 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
48 | 0.2536 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
49 | 0.315 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
50 | 0.315 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
51 | 0.315 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
52 | 0.3 | 2011-03-17 00:00:00 | 2011-06-01 00:00:00
53 | 0.2536 | 2011-03-16 00:00:00 | 2011-03-16 00:00:00
54 | 0.2614 | 2011-02-06 00:00:00 | 2011-03-16 00:00:00
55 | 0.2614 | 2011-02-06 00:00:00 | 2011-03-16 00:00:00
56 | 0.2614 | 2011-01-01 00:00:00 | 2012-02-01 00:00:00
57 | 0.2614 | 2011-01-01 00:00:00 | 2012-02-01 00:00:00
58 | 0.326 | 2011-01-01 00:00:00 | 2012-02-01 00:00:00
59 | 0.353 | 2011-01-01 00:00:00 | 2012-02-01 00:00:00
60 | 0.315 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00
61 | 0.339 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00
62 | 0.315 | 2011-01-01 00:00:00 | 2011-03-31 00:00:00
63 | 0.2614 | 2011-01-01 00:00:00 | 2011-03-16 00:00:00
64 | 0.2614 | 2011-01-01 00:00:00 | 2011-03-16 00:00:00
65 | 0.32 | 2011-01-01 00:00:00 | 2011-03-16 00:00:00
66 | 0.32 | 2011-01-01 00:00:00 | 2011-03-16 00:00:00
67 | 0.32 | 2011-01-01 00:00:00 | 2011-03-16 00:00:00
68 | 0.32 | 2011-01-01 00:00:00 | 2011-03-15 00:00:00
69 | 0.2 | 2010-12-23 00:00:00 | 2012-02-01 00:00:00
70 | 0.2 | 2010-12-23 00:00:00 | 2012-02-01 00:00:00
71 | 0.2 | 2010-11-15 00:00:00 | 2012-02-01 00:00:00
72 | 0.43 | 2010-11-15 00:00:00 | 2012-02-01 00:00:00
73 | 0.2 | 2010-10-25 00:00:00 | 2012-02-01 00:00:00
74 | 0.2 | 2010-10-22 00:00:00 | 2012-02-01 00:00:00
75 | 0.2 | 2010-10-21 00:00:00 | 2012-02-01 00:00:00
76 | 0.2 | 2010-09-16 00:00:00 | 2012-02-01 00:00:00
77 | 0.397 | 2010-09-06 00:00:00 | 2012-02-01 00:00:00
78 | 0.2 | 2010-09-06 00:00:00 | 2012-02-01 00:00:00
79 | 19.92 | 2010-09-01 00:00:00 | 2012-02-01 00:00:00
80 | 0.2 | 2010-08-26 00:00:00 | 2012-02-01 00:00:00
81 | 0.275 | 2010-08-03 00:00:00 | 2011-02-05 00:00:00
82 | 0.42 | 2010-07-28 00:00:00 | 2012-02-01 00:00:00
83 | 0.322 | 2010-07-19 00:00:00 | 2012-02-01 00:00:00
84 | 0.329 | 2010-07-08 00:00:00 | 2012-02-01 00:00:00
85 | 0.2 | 2010-06-18 00:00:00 | 2012-02-01 00:00:00
86 | 0.2 | 2010-06-14 00:00:00 | 2012-02-01 00:00:00
87 | 12.8 | 2010-05-31 00:00:00 | 2011-08-31 00:00:00
88 | 0.5 | 2010-04-20 00:00:00 | 2012-02-01 00:00:00
89 | 0.75 | 2010-04-12 00:00:00 | 2012-02-01 00:00:00
90 | 0.345 | 2010-04-01 00:00:00 | 2012-02-01 00:00:00
91 | 0.345 | 2010-04-01 00:00:00 | 2012-02-01 00:00:00
92 | 0.45 | 2010-03-24 00:00:00 | 2012-02-01 00:00:00
93 | 0.3 | 2010-03-15 00:00:00 | 2012-02-01 00:00:00
94 | 0.01 | 2010-02-01 00:00:00 | 2012-02-01 00:00:00
95 | 0.341 | 2009-12-27 00:00:00 | 2012-02-01 00:00:00
96 | 0.01 | 2009-09-01 00:00:00 | 2012-02-01 00:00:00
97 | 0.01 | 2009-08-20 00:00:00 | 2012-02-01 00:00:00
98 | 0.01 | 2009-07-31 00:00:00 | 2012-02-01 00:00:00
99 | 0.01 | 2009-07-31 00:00:00 | 2012-02-01 00:00:00
100 | 0.01 | 2009-07-13 00:00:00 | 2012-02-01 00:00:00
101 | 0.01 | 2009-07-06 00:00:00 | 2012-02-01 00:00:00
102 | 0.334 | 2009-06-26 00:00:00 | 2012-02-01 00:00:00
103 | 0.343 | 2009-04-08 00:00:00 | 2012-02-01 00:00:00
104 | 0.334 | 2009-04-07 00:00:00 | 2012-02-01 00:00:00
105 | 0.373 | 2009-04-01 00:00:00 | 2012-02-01 00:00:00
106 | 0.01 | 2009-03-30 00:00:00 | 2012-02-01 00:00:00
107 | 0.49 | 2009-03-18 00:00:00 | 2012-02-01 00:00:00
108 | 0.41 | 2009-03-11 00:00:00 | 2012-02-01 00:00:00
109 | 12 | 2009-03-10 00:00:00 | 2011-08-31 00:00:00
110 | 0.01 | 2009-02-26 00:00:00 | 2012-02-01 00:00:00
111 | 0.01 | 2009-02-10 00:00:00 | 2012-02-01 00:00:00
112 | 0.4 | 2009-02-04 00:00:00 | 2012-02-01 00:00:00
113 | 0.335 | 2009-01-21 00:00:00 | 2012-02-01 00:00:00
114 | 0.335 | 2009-01-21 00:00:00 | 2012-02-01 00:00:00
115 | 0.01 | 2009-01-14 00:00:00 | 2012-02-01 00:00:00
116 | 0.01 | 2009-01-07 00:00:00 | 2012-02-01 00:00:00
117 | 0.01 | 2009-01-07 00:00:00 | 2012-02-01 00:00:00
118 | 0.01 | 2009-01-07 00:00:00 | 2012-02-01 00:00:00
119 | 0.389 | 2008-12-28 00:00:00 | 2012-02-01 00:00:00
120 | 0.243 | 2008-11-08 00:00:00 | 2012-02-01 00:00:00
121 | 0.335 | 2008-11-03 00:00:00 | 2012-02-01 00:00:00
122 | 0.75 | 2008-10-29 00:00:00 | 2012-02-01 00:00:00
123 | 0.01 | 2008-10-08 00:00:00 | 2012-02-01 00:00:00
124 | 0.4 | 2008-10-06 00:00:00 | 2012-02-01 00:00:00
125 | 0.403 | 2008-09-28 00:00:00 | 2012-02-01 00:00:00
126 | 0.2 | 2008-09-25 00:00:00 | 2012-02-01 00:00:00
127 | 0.01 | 2008-09-25 00:00:00 | 2012-02-01 00:00:00
128 | 0.2 | 2008-09-11 00:00:00 | 2012-02-01 00:00:00
129 | 0.837 | 2008-08-27 00:00:00 | 2012-02-01 00:00:00
130 | 0.67 | 2008-08-26 00:00:00 | 2012-02-01 00:00:00
131 | 0.45 | 2008-08-19 00:00:00 | 2012-02-01 00:00:00
132 | 0.01 | 2008-08-17 00:00:00 | 2012-02-01 00:00:00
133 | 0.01 | 2008-08-17 00:00:00 | 2012-02-01 00:00:00
134 | 0.45 | 2008-08-13 00:00:00 | 2012-02-01 00:00:00
135 | 0.43 | 2008-08-13 00:00:00 | 2012-02-01 00:00:00
136 | 0.45 | 2008-08-11 00:00:00 | 2012-02-01 00:00:00
137 | 0.01 | 2008-07-24 00:00:00 | 2012-02-01 00:00:00
138 | 0.01 | 2008-07-23 00:00:00 | 2012-02-01 00:00:00
139 | 0.381 | 2008-07-06 00:00:00 | 2012-02-01 00:00:00
140 | 0.5 | 2008-07-01 00:00:00 | 2012-02-01 00:00:00
141 | 0.75 | 2008-06-25 00:00:00 | 2012-02-01 00:00:00
142 | 0.5 | 2008-06-25 00:00:00 | 2012-02-01 00:00:00
143 | 0.45 | 2008-06-23 00:00:00 | 2012-02-01 00:00:00
144 | 1.35 | 2008-06-23 00:00:00 | 2012-02-01 00:00:00
145 | 0.45 | 2008-06-22 00:00:00 | 2012-02-01 00:00:00
146 | 0.39 | 2008-06-22 00:00:00 | 2012-02-01 00:00:00
147 | 0.01 | 2008-06-12 00:00:00 | 2012-02-01 00:00:00
148 | 0.2 | 2008-06-04 00:00:00 | 2012-02-01 00:00:00
149 | 0.67 | 2008-05-27 00:00:00 | 2012-02-01 00:00:00
150 | 0.01 | 2008-05-19 00:00:00 | 2012-02-01 00:00:00
151 | 0.01 | 2008-05-07 00:00:00 | 2012-02-01 00:00:00
152 | 0.01 | 2008-05-07 00:00:00 | 2012-02-01 00:00:00
153 | 0.415 | 2008-04-11 00:00:00 | 2012-02-01 00:00:00
154 | 0.414 | 2008-04-09 00:00:00 | 2012-02-01 00:00:00
155 | 0.01 | 2008-04-08 00:00:00 | 2012-02-01 00:00:00
156 | 0.39 | 2008-04-07 00:00:00 | 2012-02-01 00:00:00
157 | 17 | 2008-04-04 00:00:00 | 2012-02-01 00:00:00
158 | 0.43 | 2008-04-01 00:00:00 | 2012-02-01 00:00:00
159 | 0.399 | 2008-04-01 00:00:00 | 2012-02-01 00:00:00
160 | 0.416 | 2008-04-01 00:00:00 | 2012-02-01 00:00:00
161 | 0.405 | 2008-02-06 00:00:00 | 2012-02-01 00:00:00
162 | 0.38 | 2008-01-17 00:00:00 | 2012-02-01 00:00:00
163 | 0.26 | 2008-01-15 00:00:00 | 2012-02-01 00:00:00
164 | 0.01 | 2008-01-13 00:00:00 | 2012-02-01 00:00:00
165 | 0.01 | 2008-01-10 00:00:00 | 2012-02-01 00:00:00
166 | 0.01 | 2008-01-10 00:00:00 | 2012-02-01 00:00:00
167 | 0.01 | 2008-01-10 00:00:00 | 2012-02-01 00:00:00
168 | 0.01 | 2008-01-07 00:00:00 | 2012-02-01 00:00:00
169 | 0.5 | 2007-12-13 00:00:00 | 2012-02-01 00:00:00
170 | 0.01 | 2007-12-06 00:00:00 | 2012-02-01 00:00:00
171 | 0.01 | 2007-11-05 00:00:00 | 2012-02-01 00:00:00
172 | 0.5 | 2007-11-04 00:00:00 | 2012-02-01 00:00:00
173 | 0.275 | 2007-10-29 00:00:00 | 2012-02-01 00:00:00
174 | 0.45 | 2007-10-29 00:00:00 | 2012-02-01 00:00:00
175 | 0.45 | 2007-10-29 00:00:00 | 2012-02-01 00:00:00
176 | 0.46 | 2007-10-26 00:00:00 | 2012-02-01 00:00:00
177 | 15.53 | 2007-10-15 00:00:00 | 2011-08-31 00:00:00
178 | 0.25 | 2007-09-13 00:00:00 | 2012-02-01 00:00:00
179 | 0.485 | 2007-09-05 00:00:00 | 2012-02-01 00:00:00
180 | 0.54 | 2007-09-05 00:00:00 | 2012-02-01 00:00:00
181 | 0.01 | 2007-08-27 00:00:00 | 2012-02-01 00:00:00
182 | 0.01 | 2007-08-20 00:00:00 | 2012-02-01 00:00:00
183 | 0.5 | 2007-08-06 00:00:00 | 2012-02-01 00:00:00
184 | 0.45 | 2007-08-05 00:00:00 | 2012-02-01 00:00:00
185 | 0.52 | 2007-08-03 00:00:00 | 2012-02-01 00:00:00
186 | 0.52 | 2007-08-01 00:00:00 | 2012-02-01 00:00:00
187 | 0.5 | 2007-08-01 00:00:00 | 2012-02-01 00:00:00
188 | 0.01 | 2007-07-19 00:00:00 | 2012-02-01 00:00:00
189 | 0.441 | 2007-07-08 00:00:00 | 2012-02-01 00:00:00
190 | 0.436 | 2007-06-28 00:00:00 | 2012-02-01 00:00:00
191 | 0.01 | 2007-06-25 00:00:00 | 2012-02-01 00:00:00
192 | 0.01 | 2007-05-08 00:00:00 | 2012-02-01 00:00:00
193 | 0.01 | 2007-05-08 00:00:00 | 2012-02-01 00:00:00
194 | 0.01 | 2007-05-08 00:00:00 | 2012-02-01 00:00:00
195 | 0.01 | 2007-05-08 00:00:00 | 2012-02-01 00:00:00
196 | 0.01 | 2007-04-29 00:00:00 | 2012-02-01 00:00:00
197 | 0.5 | 2007-04-18 00:00:00 | 2012-02-01 00:00:00
198 | 0.01 | 2007-04-15 00:00:00 | 2012-02-01 00:00:00
199 | 0.01 | 2007-04-08 00:00:00 | 2012-02-01 00:00:00
200 | 0.39 | 2007-04-08 00:00:00 | 2012-02-01 00:00:00
201 | 0.58 | 2007-03-13 00:00:00 | 2012-02-01 00:00:00
202 | 0.01 | 2007-02-27 00:00:00 | 2012-02-01 00:00:00
203 | 0.01 | 2007-02-27 00:00:00 | 2012-02-01 00:00:00
204 | 0.275 | 2007-02-07 00:00:00 | 2012-02-01 00:00:00
205 | 0.01 | 2007-01-31 00:00:00 | 2012-02-01 00:00:00
206 | 0.01 | 2007-01-30 00:00:00 | 2012-02-01 00:00:00
207 | 0.445 | 2007-01-28 00:00:00 | 2012-02-01 00:00:00
208 | 0.26 | 2006-12-08 00:00:00 | 2012-02-01 00:00:00
209 | 0.01 | 2006-12-01 00:00:00 | 2012-02-01 00:00:00
210 | 13.34 | 2006-10-25 00:00:00 | 2012-02-01 00:00:00
211 | 9.8 | 2006-10-25 00:00:00 | 2012-02-01 00:00:00
212 | 9.46 | 2006-10-25 00:00:00 | 2012-02-01 00:00:00
213 | 0.485 | 2006-10-12 00:00:00 | 2012-02-01 00:00:00
214 | 5.74 | 2006-10-12 00:00:00 | 2012-02-01 00:00:00
215 | 0.535 | 2006-09-29 00:00:00 | 2012-02-01 00:00:00
216 | 0.46 | 2005-09-16 00:00:00 | 2012-02-01 00:00:00
217 | 0.275 | 2005-09-09 00:00:00 | 2012-02-01 00:00:00
218 | 0.42 | 2005-09-09 00:00:00 | 2012-02-01 00:00:00
219 | 0.01 | 2005-09-09 00:00:00 | 2012-02-01 00:00:00
220 | 0.01 | 2005-05-16 00:00:00 | 2012-02-01 00:00:00
221 | 0.01 | 2005-05-16 00:00:00 | 2012-02-01 00:00:00
222 | 0.25 | 2005-05-16 00:00:00 | 2012-02-01 00:00:00
223 | 0.335 | 2005-05-16 00:00:00 | 2012-02-01 00:00:00
224 | 0.25 | 2005-05-16 00:00:00 | 2012-02-01 00:00:00