Sample Workbook to Using INDEX MATCH in
Excel
The workbook shows how to use INDEX MATCH in Excel to look up left in a table, search in rows and columns, look up
multiple criteria, and more.
Examples:
• Basic INDEX MATCH formula
• Left lookup with INDEX MATCH
• 2-way lookup in rows and columns
Sample Workbook to Using INDEX MATCH in
Excel
rkbook shows how to use INDEX MATCH in Excel to look up left in a table, search in rows and columns, look up
e criteria, and more.
DEX MATCH formula
kup with INDEX MATCH
ookup in rows and columns
Country Capital Population Country Japan
China Beijing 20,693,000 Capital population 13,189,000
India New Delhi 17,838,842
Japan Tokyo 13,189,000
Russia Moscow 11,541,000
South Korea Seoul 10,528,774
Indonesia Jakarta 10,187,595
Iran Tehran 9,110,347
Mexico Mexico City 8,851,080
Peru Lima 8,481,415
Rank Country Capital Population Capital Moscow
1 China Beijing 20,693,000 Rank 4
2 India New Delhi 17,838,842
3 Japan Tokyo 13,189,000
4 Russia Moscow 11,541,000
5 South Korea Seoul 10,528,774
6 Indonesia Jakarta 10,187,595
7 Iran Tehran 9,110,347
8 Mexico Mexico City 8,851,080
9 Peru Lima 8,481,415
Country 1950 2000 2015 Country: China
India 357,561 1,008,937 1,230,484 Year: 2015
China 554,760 1,275,133 1,410,217 Population: 1,410,217
USA 157,813 283,230 321,225
Pakistan 39,659 141,256 204,267
Indonesia 79,538 212,092 250,068
Nigeria 29,790 113,862 165,313
Bangladesh 41,783 137,439 183,159
Brazil 53,975 170,406 201,393
Congo 12,184 50,948 84,045
Ethiopia 18,434 62,908 89,765
