Introduction

When working with Excel in financial modeling, relying only on VLOOKUP or HLOOKUP can be limiting. That’s where the INDEX MATCH formula combination shines. If you are searching for an index match practice exercises xls download, this post gives you exactly that — a free file with practice problems and solutions to master lookups in Excel.

INDEX MATCH Practice Exercises XLS Download

What is INDEX + MATCH?

  • INDEX: Returns a value from a range based on row/column numbers.
  • MATCH: Finds the position of a value in a row/column.
  • Combined: Together, they allow dynamic lookups (more flexible than VLOOKUP/HLOOKUP).

Formula Pattern:

=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))

Practice Dataset

We’ll use a Sales Data Table:

Product IDProduct NameCategoryRegionSales
101LaptopElectronicsNorth5000
102PhoneElectronicsSouth3000
103ChairFurnitureEast1500
104DeskFurnitureWest2500
105MonitorElectronicsNorth4000

INDEX MATCH Practice Problems

  1. Find the sales of “Phone”.
  2. Get the Region for Product ID 104.
  3. Find the Category of “Monitor”.
  4. Lookup Sales for Product ID 101.
  5. Find the Product Name sold in the East region.
  6. Return the Region for Product Name = Chair.
  7. Find Sales where Product ID = 105.
  8. Get Category for Product ID 102.
  9. Find Product Name for Sales = 2500.
  10. Lookup Region for Product Name = Laptop.

INDEX MATCH Practice Exercises XLS Solutions

  1. =INDEX(E2:E6, MATCH("Phone", B2:B6, 0)) → 3000
  2. =INDEX(D2:D6, MATCH(104, A2:A6, 0)) → West
  3. =INDEX(C2:C6, MATCH("Monitor", B2:B6, 0)) → Electronics
  4. =INDEX(E2:E6, MATCH(101, A2:A6, 0)) → 5000
  5. =INDEX(B2:B6, MATCH("East", D2:D6, 0)) → Chair
  6. =INDEX(D2:D6, MATCH("Chair", B2:B6, 0)) → East
  7. =INDEX(E2:E6, MATCH(105, A2:A6, 0)) → 4000
  8. =INDEX(C2:C6, MATCH(102, A2:A6, 0)) → Electronics
  9. =INDEX(B2:B6, MATCH(2500, E2:E6, 0)) → Desk
  10. =INDEX(D2:D6, MATCH("Laptop", B2:B6, 0)) → North

What You’ll Learn from This Template

This INDEX MATCH practice exercises XLS will help you:

  • Build flexible lookups in any direction (not just left-to-right).
  • Replace VLOOKUP/HLOOKUP in financial models.
  • Create dynamic, scalable formulas for real-world Excel reporting.

Ready to start? Download the free practice file here and begin mastering INDEX MATCH today.