Spreadsheet: 168627d1342529141-vlookup-with-3-search-criteria-excel_test
Sheet: Sheet2

Sum of Price Per Unit |  |  | Lot Name
Supplier | Plant | Item | 2013 | 2014 | 2015 | Grand Total
CARGILL | Altavista | 1302 | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | 1305 | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | 1310 | 0.2675 |  |  | 0.2675
 | Casa/Fairfield | 1302 | 0.2216 | 0.2226 | 0.2235 | 0.6677
 |  | 1305 | 0.235 | 0.2361 | 0.2371 | 0.7081999999999999
 |  | 1310 | 0.29 |  |  | 0.29
 |  | R0424 | 0.2915 |  |  | 0.2915
 | Columbus | 1302 | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | 1305 | 0.1633 | 0.164 | 0.1647 | 0.492
 |  | 1310 Syrup | 0.25 |  |  | 0.25
 | Cootehill | 20893 | 0.925 | 0.925 | 0.925 | 2.775
 | EU TPM | 1310 |  | 0.476 |  | 0.476
 | Granada | 1136 | 1.421 | 1.421 | 1.421 | 4.263
 |  | 43940 | 1.56 | 1.56 | 1.56 | 4.68
 |  | 55832 | 0.925 | 0.925 | 0.925 | 2.775
 |  | 81589 | 0.19 | 0.19 | 0.19 | 0.57
 |  | 55832 Big Bag |  | 0.925 | 0.925 | 1.85
 |  | 55832 Big Bag | 0.925 |  |  | 0.925
 | Singapore | 36668 | 0.787 | 0.823 | 0.854 | 2.464
 |  | 87543 | 0.787 | 0.823 | 0.854 | 2.464
 | Sturgis | 1302 | 0.2216 | 0.2226 | 0.2235 | 0.6677
 |  | 1305 | 0.235 | 0.2361 | 0.2371 | 0.7081999999999999
 |  | 1310 | 0.2525 |  |  | 0.2525
 | Zwolle | 1136 | 1.421 | 1.421 | 1.421 | 4.263
 |  | 1302 | 0.925 | 0.925 | 0.925 | 2.775
 |  | 1310 | 0.476 | 0.476 | 0.476 | 1.428
 |  | 32098 | 0.501 | 0.501 | 0.501 | 1.503
 |  | 43940 | 1.56 | 1.56 | 1.56 | 4.68
 |  | 72139 | 0.925 | 0.925 | 0.925 | 2.775
 |  | 1136B | 1.421 | 1.421 | 1.421 | 4.263
 |  | 31961B Big Bag | 0.925 | 0.925 | 0.925 | 2.775
 |  | 72139A | 0.925 | 0.925 | 0.925 | 2.775
Grain Processing Corp | Altavista | 1302 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1305 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1313 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1315 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1316 | 0.363 | 0.373 | 0.383 | 1.119
 | Casa/Fairfield | 1302 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1305 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1313 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1315 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1316 | 0.363 | 0.373 | 0.383 | 1.119
 | Columbus | 1302 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1305 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1313 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1316 | 0.363 | 0.373 | 0.383 | 1.119
 | Sturgis | 1302 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1305 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1313 | 0.313 | 0.323 | 0.333 | 0.9690000000000001
 |  | 1315 | 0.313 | 0.323 | 0.335 | 0.9710000000000001
 |  | 1316 | 0.363 | 0.373 | 0.383 | 1.119
 |  | R0587 | 0.548 | 0.558 |  | 1.106
 |  | R0587. |  |  | 0.568 | 0.568
 | Zwolle | 39298 | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | 72139 | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | 73914 | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | [NAME] | 1.0978 |  |  | 1.0978
 |  | 39298A Big Bag | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | 72139A | 1.0978 | 1.1199 | 1.142 | 3.3597
 |  | [NAME] |  | 1.1199 | 1.142 | 2.2619
Roquette | Columbus | 23235 | 0.442 |  |  | 0.442
 | Cootehill | 20893 | 0.99 |  |  | 0.99
 | Granada | 31961 | 0.91 |  |  | 0.91
 |  | 43940 | 2.18 |  |  | 2.18
 |  | 55832 | 0.91 |  |  | 0.91
 |  | 81589 | 0.53 |  |  | 0.53
 |  | 31961 Big Bag | 0.91 |  |  | 0.91
 |  | 55832 Big Bag | 0.91 |  |  | 0.91
 | Singapore | 36668 | 0.99 |  |  | 0.99
 |  | 87543 | 0.98 |  |  | 0.98
 | Zwolle | 1310 | 0.535 |  |  | 0.535
 |  | 31961 | 0.915 |  |  | 0.915
 |  | 43940 | 2.18 |  |  | 2.18
 |  | 31961B Big Bag | 0.915 |  |  | 0.915
 |  | 43940B Big Bag | 2.18 |  |  | 2.18
Tate & Lyle | Altavista | 1302 |  | 0.395 |  | 0.395
 |  | 1305 | 0.365 |  | 0.375 | 0.74
 |  | 1315 | 0.3675 | 0.4 | 0.39 | 1.1575
 | Casa/Fairfield | 1305 | 0.367 | 0.3699 | 0.3729 | 1.1098
 |  | 1313 | 0.3676 | 0.3706 | 0.3736 | 1.1118
 |  | 1315 | 0.367 | 0.3699 | 0.3729 | 1.1098
 | Columbus | 1305 | 0.312 | 0.312 | 0.3145 | 0.9385
 |  | 1313 | 0.367 | 0.368 | 0.3736 | 1.1086
 |  | 1310 Syrup | 0.255 |  |  | 0.255
 | EU TPM | 1302 | 0.735 |  |  | 0.735
 |  | 1310 | 0.85 |  |  | 0.85
 |  | 20893 | 0.755 |  |  | 0.755
 |  | 36668 | 1.51 |  |  | 1.51
 | Granada | 31961 | 0.785 |  |  | 0.785
 |  | 55832 | 0.78 |  |  | 0.78
 |  | 31961 Big Bag | 0.78 |  |  | 0.78
 |  | 55832 Big Bag | 0.8 |  |  | 0.8
 | Sturgis | 1305 | 0.369 | 0.37 | 0.3729 | 1.1119
 |  | 1310 | 0.2506 | 0.38 |  | 0.6306
 |  | 1313 | 0.367 | 0.3699 | 0.3736 | 1.1105
 |  | 1315 | 0.367 | 0.3699 | 0.3729 | 1.1098
 | Zwolle | 1302 | 0.85 |  |  | 0.85
 |  | 31961 | 0.8 |  |  | 0.8
 |  | 13691B Big Bag |  |  | 0.85 | 0.85
 |  | 31961B Big Bag | 0.8 |  |  | 0.8
Tereos Syral | China | 36668 | 909.3 | 920 | 930 | 2759.3
 |  | 87543 | 909.3 | 920 | 930 | 2759.3
 | Cootehill | 20893 | 0.834 | 0.834 | 0.834 | 2.502
 | EU TPM | 1302 | 0.74 | 0.834 | 0.834 | 2.408
 |  | 1310 | 0.564 | 0.564 | 0.564 | 1.692
 |  | 20893 | 0.765 | 0.834 | 0.834 | 2.433
 |  | 36668 | 1.524 | 1.668 | 1.668 | 4.86
 | Granada | 1136 | 0.914 | 0.914 | 0.914 | 2.742
 |  | 13691 | 0.914 | 0.914 | 0.914 | 2.742
 |  | 31961 | 0.7923 | 0.834 | 0.834 | 2.4603
 |  | 43940 | 1.746 | 1.746 | 1.746 | 5.238
 |  | 55832 | 0.7923 | 0.834 | 0.834 | 2.4603
 |  | 81589 | 0.525 | 0.564 | 0.564 | 1.653
 |  | 31961 Big Bag | 0.7923 | 0.834 | 0.834 | 2.4603
 |  | 55832 Big Bag |  | 0.834 | 0.834 | 1.668
 |  | 55832 Big Bag | 0.834 |  |  | 0.834
 | Singapore | 36668 | 0.982 | 1.034 | 1.034 | 3.05
 |  | 87543 | 0.982 | 1.034 | 1.034 | 3.05
 | Zwolle | 1136 | 0.914 | 0.914 | 0.914 | 2.742
 |  | 1302 | 0.834 | 0.834 | 0.834 | 2.502
 |  | 1310 | 0.525 | 0.564 | 0.564 | 1.653
 |  | 13691 | 0.914 | 0.914 | 0.914 | 2.742
 |  | 31961 | 0.834 | 0.834 | 0.834 | 2.502
 |  | 32098 | 0.598 | 0.834 | 0.834 | 2.266
 |  | 39298 | 0.834 | 0.834 | 0.834 | 2.502
 |  | 43940 | 1.66 | 1.746 | 1.746 | 5.151999999999999
 |  | 72139 | 0.834 | 0.834 | 0.834 | 2.502
 |  | 73914 | 0.834 | 0.834 | 0.834 | 2.502
 |  | [NAME] | 0.834 |  |  | 0.834
 |  | 1136B | 0.914 | 0.914 | 0.914 | 2.742
 |  | 13691B Big Bag | 0.914 | 0.914 | 0.914 | 2.742
 |  | 31961B Big Bag | 0.834 | 0.834 | 0.834 | 2.502
 |  | 39298A Big Bag | 0.834 | 0.834 | 0.834 | 2.502
 |  | 43940B Big Bag | 1.746 | 1.746 | 1.746 | 5.238
 |  | 72139A | 0.834 | 0.834 | 0.834 | 2.502
 |  | [NAME] |  | 0.834 | 0.834 | 1.668
Grand Total |  |  | 1910.834300000001 | 1906.738000000002 | 1927.131900000001 | 5744.704200000005