Spreadsheet: 168617d1342527305-vlookup-with-3-search-criteria-excel_test
Sheet: Supplier Rank Pivot

Plant | Item | Supplier | 2013 Rank | 2014 Rank | 2015 Rank |  |  |  |  |  |  | Cargill | Grain Processing Corp | Roquette | Tate & Lyle | Tereos Syral
Altavista | 1302 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 |  | Tate & Lyle | X | 3 | X
 | 1305 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2 |  |  |  |  |  |  | 50 | 36 | 2 | 11 | 70
 |  | Tate & Lyle | 3 | X | 3 |  |  |  |  |  |  | 27 | 33 | 2 | 25 | 30
 | 1310 | CARGILL | 1 | X | X |  |  |  |  |  |  | 1 | 9 | 11 | 9 | 2
 | 1313 | Grain Processing Corp | 1 | 1 | 1
 | 1315 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1316 | Grain Processing Corp | 1 | 1 | 1
Casa/Fairfield | 1302 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 | 1305 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 |  | Tate & Lyle | 3 | 3 | 3
 | 1310 | CARGILL | 1 | X | X
 | 1313 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1315 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1316 | Grain Processing Corp | 1 | 1 | 1
 | R0424 | CARGILL | 1 | X | X
China | 36668 | Tereos Syral | 1 | 1 | 1
 | 87543 | Tereos Syral | 1 | 1 | 1
Columbus | 1302 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 | 1305 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 3 | 3 | 3
 |  | Tate & Lyle | 2 | 2 | 2
 | 1313 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1316 | Grain Processing Corp | 1 | 1 | 1
 | 23235 | Roquette | 1 | X | X
 | 1310 Syrup | CARGILL | 1 | X | X
 |  | Tate & Lyle | 2 | X | X
Cootehill | 20893 | CARGILL | 2 | 2 | 2
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 1 | 1 | 1
EU TPM | 1302 | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 1310 | CARGILL | X | 1 | X
 |  | Tate & Lyle | 2 | X | X
 |  | Tereos Syral | 1 | 2 | 1
 | 20893 | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 36668 | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
Granada | 1136 | CARGILL | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | 13691 | Tereos Syral | 1 | 1 | 1
 | 31961 | Roquette | 3 | X | X
 |  | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 43940 | CARGILL | 1 | 1 | 1
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 2 | 2 | 2
 | 55832 | CARGILL | 4 | 2 | 2
 |  | Roquette | 3 | X | X
 |  | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 81589 | CARGILL | 1 | 1 | 1
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 2 | 2 | 2
 | 31961 Big Bag | Roquette | 1 | X | X
 |  | Tate & Lyle | 2 | X | X
 |  | Tereos Syral | 3 | 1 | 1
 | 55832 Big Bag | CARGILL | X | 2 | 2
 |  | Tereos Syral | X | 1 | 1
 | 55832 Big Bag | CARGILL | 4 | X | X
 |  | Roquette | 3 | X | X
 |  | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | X | X
Singapore | 36668 | CARGILL | 1 | 1 | 1
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 2 | 2 | 2
 | 87543 | CARGILL | 1 | 1 | 1
 |  | Roquette | 2 | X | X
 |  | Tereos Syral | 3 | 2 | 2
Sturgis | 1302 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 | 1305 | CARGILL | 1 | 1 | 1
 |  | Grain Processing Corp | 2 | 2 | 2
 |  | Tate & Lyle | 3 | 3 | 3
 | 1310 | CARGILL | 2 | X | X
 |  | Tate & Lyle | 1 | 1 | X
 | 1313 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1315 | Grain Processing Corp | 1 | 1 | 1
 |  | Tate & Lyle | 2 | 2 | 2
 | 1316 | Grain Processing Corp | 1 | 1 | 1
 | R0587 | Grain Processing Corp | 1 | 1 | X
 | R0587. | Grain Processing Corp | X | X | 1
Zwolle | 1136 | CARGILL | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | 1302 | CARGILL | 3 | 2 | 2
 |  | Tate & Lyle | 2 | X | X
 |  | Tereos Syral | 1 | 1 | 1
 | 1310 | CARGILL | 1 | 1 | 1
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 2 | 2 | 2
 | 13691 | Tereos Syral | 1 | 1 | 1
 | 31961 | Roquette | 3 | X | X
 |  | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 32098 | CARGILL | 1 | 1 | 1
 |  | Tereos Syral | 2 | 2 | 2
 | 39298 | Grain Processing Corp | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | 43940 | CARGILL | 1 | 1 | 1
 |  | Roquette | 3 | X | X
 |  | Tereos Syral | 2 | 2 | 2
 | 72139 | CARGILL | 2 | 2 | 2
 |  | Grain Processing Corp | 3 | 3 | 3
 |  | Tereos Syral | 1 | 1 | 1
 | 73914 | Grain Processing Corp | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | [NAME] | Grain Processing Corp | 2 | X | X
 |  | Tereos Syral | 1 | X | X
 | 1136B | CARGILL | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | 13691B Big Bag | Tate & Lyle | X | X | 1
 |  | Tereos Syral | 1 | 1 | 2
 | 31961B Big Bag | CARGILL | 4 | 2 | 2
 |  | Roquette | 3 | X | X
 |  | Tate & Lyle | 1 | X | X
 |  | Tereos Syral | 2 | 1 | 1
 | 39298A Big Bag | Grain Processing Corp | 2 | 2 | 2
 |  | Tereos Syral | 1 | 1 | 1
 | 43940B Big Bag | Roquette | 2 | X | X
 |  | Tereos Syral | 1 | 1 | 1
 | 72139A | CARGILL | 2 | 2 | 2
 |  | Grain Processing Corp | 3 | 3 | 3
 |  | Tereos Syral | 1 | 1 | 1
 | [NAME] | Grain Processing Corp | X | 2 | 2
 |  | Tereos Syral | X | 1 | 1
Grand Total