---
title: "INDEX and MATCH practice exercises | PracticeExcel"
description: "Practice INDEX and MATCH in a live spreadsheet, including lookups to the left."
canonical_url: "https://practiceexcelonline.com/practice/index-match"
locale: en
meta:
  "og:description": "Practice INDEX and MATCH in a live spreadsheet, including lookups to the left."
  "og:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_INDEX%2Band%2BMATCH%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgaW5jbHVkaW5nIGxvb2t1cHMgdG8gdGhlIGxlZnQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9pbmRleC1tYXRjaCI%2Cs_BQsch5nHQtaSJGt8.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "INDEX and MATCH practice exercises | PracticeExcel"
  "twitter:image": "https://practiceexcelonline.com/_og/d/c_Page%2Ctitle_INDEX%2Band%2BMATCH%2Bpractice%2Bexercises%2Cdescription_~UHJhY3RpY2UgSU5ERVggYW5kIE1BVENIIGluIGEgbGl2ZSBzcHJlYWRzaGVldCwgaW5jbHVkaW5nIGxvb2t1cHMgdG8gdGhlIGxlZnQu%2Ceyebrow_Excel%2Bpractice%2Bexercises%2Csite_practiceexcel%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiLCJEIiwiRSJdLCJyb3dzIjpbeyJuIjoxLCJjZWxscyI6WyJQcm9kdWN0IiwiUHJpY2UiLCJQcm9kdWN0IiwiUG9zaXRpb24iXX0seyJuIjoyLCJjZWxscyI6WyJBcHBsZXMiLCIyMiIsIkRhdGVzIiwiIl19LHsibiI6MywiY2VsbHMiOlsiQmFuYW5hcyIsIjE4IiwiIiwiIl19LHsibiI6NCwiY2VsbHMiOlsiQ2hlcnJpZXMiLCI0NSIsIiIsIiJdfSx7Im4iOjUsImNlbGxzIjpbIkRhdGVzIiwiMzgiLCIiLCIiXX0seyJuIjo2LCJjZWxscyI6WyJGaWdzIiwiNiIsIiIsIiJdfV0sInRhcmdldCI6WzEsM119fQ%2Cp_Ii9wcmFjdGljZS9pbmRleC1tYXRjaCI%2Cs_BQsch5nHQtaSJGt8.png"
---

> Index of every page on this site: [llms.txt](https://practiceexcelonline.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://practiceexcelonline.com/practice/index-match/match-function)

INDEX(MATCH(

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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.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://practiceexcelonline.com/practice/index-match/index-match-match-two-way)

## **Functions in this topic**

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

## **Read the guide**

- [**Excel for job interviews: what gets tested and how to prepare**](https://practiceexcelonline.com/learn/excel-for-job-interviews)
- [**VLOOKUP vs XLOOKUP vs INDEX MATCH: which lookup to use**](https://practiceexcelonline.com/learn/vlookup-vs-xlookup-vs-index-match)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://practiceexcelonline.com/#identity","@type":"Organization","name":"PracticeExcel","url":"https://practiceexcelonline.com/","logo":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/#website","@type":"WebSite","inLanguage":"en-US","name":"PracticeExcel","url":"https://practiceexcelonline.com/","alternateName":["Practice Excel Online","PracticeExcelOnline.com"],"publisher":{"@id":"https://practiceexcelonline.com/#identity"},"workTranslation":{"@id":"https://excelopgaver.dk/#website"}},{"@id":"https://practiceexcelonline.com/practice/index-match#webpage","description":"Practice INDEX and MATCH in a live spreadsheet, including lookups to the left.","name":"INDEX and MATCH practice exercises","url":"https://practiceexcelonline.com/practice/index-match","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://practiceexcelonline.com/practice/index-match#breadcrumb"},"isPartOf":{"@id":"https://practiceexcelonline.com/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://practiceexcelonline.com/practice/index-match"]}],"primaryImageOfPage":{"@id":"https://practiceexcelonline.com/#logo"}},{"@id":"https://practiceexcelonline.com/practice/index-match#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Home","item":"https://practiceexcelonline.com","position":1},{"@type":"ListItem","name":"Excel practice exercises","item":"https://practiceexcelonline.com/practice","position":2},{"@type":"ListItem","name":"INDEX and MATCH practice exercises","position":3}]},{"@id":"https://practiceexcelonline.com/#logo","@type":"ImageObject","caption":"PracticeExcel","contentUrl":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png","inLanguage":"en-US","url":"https://practiceexcelonline.com/brand/practiceexcel/icon-512.png"}]}
```

## Sitemap

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