---
title: "INDEX and MATCH practice: 4 exercises with answers"
description: "Practice INDEX and MATCH in Excel: find a position, look up a price, look to the left and do a two-way lookup, checked in a live spreadsheet."
canonical_url: "https://excelsavvy.com/practice/index-match"
meta:
  "og:description": "Practice INDEX and MATCH in Excel: find a position, look up a price, look to the left and do a two-way lookup, checked in a live spreadsheet."
  "og:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~SU5ERVggYW5kIE1BVENIIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIEV4Y2VsOiBmaW5kIGEgcG9zaXRpb24sIGxvb2sgdXAgYSBwcmljZSwgbG9vayB0byB0aGUgbGVmdCBhbmQgZG8gYSB0d28td2F5IGxvb2t1cCwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9pbmRleC1tYXRjaCI%2Cs_E5Tv6QBKIAhlR6EG.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "INDEX and MATCH practice: 4 exercises with answers"
  "twitter:image": "https://excelsavvy.com/_og/d/c_Page%2Ctitle_~SU5ERVggYW5kIE1BVENIIHByYWN0aWNlOiA0IGV4ZXJjaXNlcyB3aXRoIGFuc3dlcnM%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIEV4Y2VsOiBmaW5kIGEgcG9zaXRpb24sIGxvb2sgdXAgYSBwcmljZSwgbG9vayB0byB0aGUgbGVmdCBhbmQgZG8gYSB0d28td2F5IGxvb2t1cCwgY2hlY2tlZCBpbiBhIGxpdmUgc3ByZWFkc2hlZXQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9pbmRleC1tYXRjaCI%2Cs_E5Tv6QBKIAhlR6EG.png"
---

> Index of every page on this site: [llms.txt](https://excelsavvy.com/llms.txt)

# **INDEX and MATCH practice exercises**

MATCH finds the position of a value; INDEX returns the value at a position. Together they look up in any direction, also to the left.

[**Start the first exercise**](https://excelsavvy.com/practice/index-match/match-function)

INDEX(MATCH(

## **How INDEX and MATCH work together**

MATCH finds where a value sits in a list and returns that position as a number. INDEX does the opposite: you give it a range and a position, and it returns the value there. MATCH takes the value to find, the range to search and 0 for an exact match. INDEX takes the range to return from and a row number. Both work the same in Excel and Google Sheets.

`**=INDEX(C2:C7,MATCH(E2,A2:A7,0))**` finds the product from E2 in A2:A7 and returns the price from the same row in C2:C7. The two ranges are separate, so the answer can sit left of the lookup column. `**=INDEX(B2:E5,MATCH(H1,A2:A5,0),MATCH(H2,B1:E1,0))**` is a two-way lookup: one MATCH picks the row and the other picks the column.

The classic mistake is forgetting the 0 in MATCH. Then it looks for the nearest smaller value and can return a wrong row without any error. Start both ranges on the same row, or the position points to the wrong cell. XLOOKUP needs less typing, but INDEX and MATCH works in every version. The exercises below cover finding a position, a price lookup, looking to the left and a two-way lookup.

1. [**1****Find a position with MATCH**In E2, use MATCH to find the position of the product in D2 within A2:A7. Add 0 as the last argument for an exact match.](https://excelsavvy.com/practice/index-match/match-function)
2. [**2****Look up a price with INDEX and MATCH****Premium**In F2, return the Price of the product in E2. Use MATCH to find its row in A2:A7 and INDEX to pick that row from C2:C7.](https://excelsavvy.com/practice/index-match/index-match)
3. [**3****Look to the left with INDEX and MATCH****Premium**The IDs are in column C, to the right of the names. In F2, return the Name for the ID in E2 with INDEX and MATCH.](https://excelsavvy.com/practice/index-match/index-match-left-lookup)
4. [**4****A two-way lookup with INDEX and two MATCHes****Premium**In H3, find the sales for the product in H1 and the region in H2. INDEX the numbers B2:E5 with one MATCH for the row and one for the column: INDEX(B2:E5,MATCH(H1,A2:A5,0),MATCH(H2,B1:E1,0)).](https://excelsavvy.com/practice/index-match/index-match-match-two-way)

## **Functions in this topic**

- [**INDEX**](https://excelsavvy.com/functions/index)
- [**MATCH**](https://excelsavvy.com/functions/match)

## **Read the guide**

- [**Excel test for a job interview: what it looks like and how to practice**](https://excelsavvy.com/learn/excel-for-job-interviews)
- [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**](https://excelsavvy.com/learn/vlookup-vs-xlookup-vs-index-match)
- [**Excel inventory data: free practice file with tasks and answers**](https://excelsavvy.com/learn/excel-inventory-data)
- [**Best advanced Excel courses in 2026: what to learn and where**](https://excelsavvy.com/learn/best-advanced-excel-courses)

## **Questions**

<details>

<summary>

### How do I use INDEX MATCH with multiple criteria?

</summary>

In Excel 365, multiply the tests inside MATCH and look for 1: =INDEX(C2:C20,MATCH(1,(A2:A20=F1)\*(B2:B20=F2),0)). The product is 1 only on rows where both tests are true. In older versions of Excel, confirm the formula with Ctrl+Shift+Enter so it runs as an array formula.

</details>

<details>

<summary>

### Is INDEX MATCH better than VLOOKUP?

</summary>

For most jobs, yes. INDEX and MATCH can look to the left, and the formula does not break when you insert a column in the table, because you point at whole columns instead of counting a column number. VLOOKUP is shorter to write and fine for a simple lookup to the right.

</details>

<details>

<summary>

### How do I return a whole row with INDEX MATCH?

</summary>

Set the column argument of INDEX to 0: =INDEX(A2:E20,MATCH(G1,A2:A20,0),0) returns the entire matching row. In Excel 365 the row spills into the cells to the right. In older versions it only works inside another function, such as SUM, or as an array formula.

</details>

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelsavvy.com/#identity","@type":"Organization","name":"ExcelSavvy","url":"https://excelsavvy.com/","logo":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/#website","@type":"WebSite","inLanguage":"en-US","name":"ExcelSavvy","url":"https://excelsavvy.com/","alternateName":["Excel Savvy","ExcelSavvy.com","PracticeExcel","Practice Excel Online"],"publisher":{"@id":"https://excelsavvy.com/#identity"},"workTranslation":[{"@id":"https://excelopgaver.dk/#website"},{"@id":"https://excelpraxis.de/#website"}]},{"@id":"https://excelsavvy.com/practice/index-match#webpage","description":"Practice INDEX and MATCH in Excel: find a position, look up a price, look to the left and do a two-way lookup, checked in a live spreadsheet.","name":"INDEX and MATCH practice: 4 exercises with answers","url":"https://excelsavvy.com/practice/index-match","@type":["WebPage","CollectionPage","FAQPage"],"breadcrumb":{"@id":"https://excelsavvy.com/practice/index-match#breadcrumb"},"isPartOf":{"@id":"https://excelsavvy.com/#website"},"mainEntity":[{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/1"},{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/2"},{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/3"}],"potentialAction":[{"@type":"ReadAction","target":["https://excelsavvy.com/practice/index-match"]}],"primaryImageOfPage":{"@id":"https://excelsavvy.com/#logo"}},{"@id":"https://excelsavvy.com/practice/index-match#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://excelsavvy.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://excelsavvy.com/practice","position":2},{"@type":"ListItem","name":"INDEX and MATCH practice: 4 exercises with answers","position":3}]},{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/1","@type":"Question","inLanguage":"en-US","name":"How do I use INDEX MATCH with multiple criteria?","acceptedAnswer":{"@type":"Answer","text":"In Excel 365, multiply the tests inside MATCH and look for 1: =INDEX(C2:C20,MATCH(1,(A2:A20=F1)*(B2:B20=F2),0)). The product is 1 only on rows where both tests are true. In older versions of Excel, confirm the formula with Ctrl+Shift+Enter so it runs as an array formula."}},{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/2","@type":"Question","inLanguage":"en-US","name":"Is INDEX MATCH better than VLOOKUP?","acceptedAnswer":{"@type":"Answer","text":"For most jobs, yes. INDEX and MATCH can look to the left, and the formula does not break when you insert a column in the table, because you point at whole columns instead of counting a column number. VLOOKUP is shorter to write and fine for a simple lookup to the right."}},{"@id":"https://excelsavvy.com/practice/index-match#/schema/question/3","@type":"Question","inLanguage":"en-US","name":"How do I return a whole row with INDEX MATCH?","acceptedAnswer":{"@type":"Answer","text":"Set the column argument of INDEX to 0: =INDEX(A2:E20,MATCH(G1,A2:A20,0),0) returns the entire matching row. In Excel 365 the row spills into the cells to the right. In older versions it only works inside another function, such as SUM, or as an array formula."}},{"@id":"https://excelsavvy.com/#logo","@type":"ImageObject","caption":"ExcelSavvy","contentUrl":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3","inLanguage":"en-US","url":"https://excelsavvy.com/brand/practiceexcel/icon-512.png?v=3"}]}
```

## Sitemap

See the full [sitemap](https://excelsavvy.com/sitemap.md) for all pages.
