Skip to content
GridBelt
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign in
Start the free test
  • Excel Test
  • Practice
  • Programs
  • Pricing
Sign inCreate account
Start the free test
GridBelt

Practice Excel in your browser.

Excel Test

  • Level 1: Beginner
  • Level 2: Intermediate
  • Level 3: Expert
  • Excel test in 7 days
  • Leaderboard
  • Excel test for interview
  • Indeed Excel assessment

Practice

  • All exercises
  • Programs
  • For beginners

Guides

  • Excel formulas
  • Excel shortcuts

Company

  • About
  • Pricing
  • How we grade

© GridBelt. All rights reserved.

  • Privacy Policy
  • Terms of Use
  • Refund Policy

Excel is a trademark of Microsoft Corporation. Indeed, TestGorilla, SHL and other marks are the property of their owners. GridBelt is an independent practice site and is not affiliated with, endorsed by or sponsored by Microsoft, TestGorilla, SHL or Indeed.

  1. Practice
  2. /
  3. INDEX and MATCH

INDEX MATCH MATCH practice: two-way lookup in a sales matrix

  • Expert
  • ~8 min
  • INDEX and MATCH

The 2026 sales matrix has the twelve months down column A and 8 regions across row 1 — 96 cells of monthly sales. Management wants to type a month in B16 and a region in B17 and read the matching sales figure in B18. Neither VLOOKUP nor HLOOKUP alone can do this: the row and the column both come from inputs, so INDEX needs two MATCH functions, one for each axis.

What you need to do

  1. 1Click B18 and type =INDEX($B$2:$I$13, — the matrix of numbers without its labels is the range INDEX will read from.
  2. 2Add the row number: MATCH(B16,$A$2:$A$13,0) finds the month's position in column A (Aug is 8).
  3. 3Add the column number: MATCH(B17,$B$1:$I$1,0) finds the region's position in row 1. Close the bracket: =INDEX($B$2:$I$13,MATCH(B16,$A$2:$A$13,0),MATCH(B17,$B$1:$I$1,0)).
  4. 4Press Enter, then change B16 to Mar and B17 to Pacific Northwest — B18 must follow each change.

Answer cells

Feedback

Type your formula in the grid, press Enter, then Check. We grade the value in each answer cell and the formula behind it.

Tasks

  1. Not checkedIn B18, use INDEX with two MATCH functions to return the sales for the month in B16 (matched in A2:A13) and the region in B17 (matched in B1:I1) from the matrix B2:I13.

Desktop recommended for spreadsheet tasks. The sheet scrolls inside this box.

StartInsertFormulasDataView
A1fxPreparing your workbook…
A
B
C
D
E
F
G
H
I
J
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Sheet1

Enter your formula in the sheet, then check.

About this exercise

A 17-row dataset on one sheet, one answer cell, about 8 minutes. Graded in your browser: the value and the formula behind it, with feedback that names the fix.

How to solve it

  • B18=INDEX($B$2:$I$13,MATCH(B16,$A$2:$A$13,0),MATCH(B17,$B$1:$I$1,0))

INDEX(range, row, column) returns the cell at a given row and column position inside the range — here the 8th row and the 5th column of $B$2:$I$13, which is cell F9. The two MATCH functions supply those positions from the labels: one searches the month names in column A, the other the region names in row 1, each with 0 for an exact match. Because every part is looked up, the same formula serves all 96 combinations without being edited.

Pitfall 1: the three ranges must line up — the matrix starts at B2, so the month MATCH must start at A2 and the region MATCH at B1; a MATCH over A1:A13 is one position too large and returns the next month's row. Pitfall 2: labels must match exactly: "Pacific NW" will not find "Pacific Northwest" and MATCH returns #N/A; data-validation lists on the input cells prevent typos. Pitfall 3: a hard-coded position (=INDEX($B$2:$I$13,8,MATCH(…))) looks right until the month input changes — exactly what the grader tests. Alternatives: =VLOOKUP(B16,$A$2:$I$13,MATCH(B17,$A$1:$I$1,0),FALSE) uses VLOOKUP for the row and MATCH for the column; =SUMPRODUCT(($A$2:$A$13=B16)*($B$1:$I$1=B17)*$B$2:$I$13) multiplies two boolean masks by the matrix; in 365, =XLOOKUP(B17,$B$1:$I$1,XLOOKUP(B16,$A$2:$A$13,$B$2:$I$13)) nests two XLOOKUPs (the inner one returns a whole row). Modeling note: two-way lookups are how dashboards read rate cards, price grids and budget matrices; INDEX with a 0 as row or column even returns an entire row or column for charts and spills.

Other ways that work

  • =VLOOKUP(B16,$A$2:$I$13,MATCH(B17,$A$1:$I$1,0),FALSE) — VLOOKUP for the row, MATCH for the column (not accepted here: this task practices INDEX with two MATCH functions)
  • =INDEX($A$1:$I$13,MATCH(B16,$A$1:$A$13,0),MATCH(B17,$A$1:$I$1,0)) — INDEX over the whole block including labels; both MATCH ranges then start at A1
  • =SUMPRODUCT(($A$2:$A$13=B16)*($B$1:$I$1=B17)*$B$2:$I$13) — boolean-mask alternative, no INDEX (not accepted here)

Common mistakes

Mixing up the order of INDEX's arguments: =INDEX($B$2:$I$13,MATCH(B17,$B$1:$I$1,0),MATCH(B16,$A$2:$A$13,0)) feeds the region position as the row number and returns a value from the wrong cell — INDEX wants row first, then column.

How we grade

Any formula that produces the right result is accepted, unless the task names a function: then another function earns half credit. We compare values with a small tolerance and ignore case and spaces in text. A correct number typed by hand instead of a formula earns half credit. Multi-cell tasks earn full credit at 100% of cells, half credit from 50%. Where it matters, we also change an input cell on a copy of your sheet and check that your formula follows.

Answers computed with Excel 365 rules and checked in our grading engine on November 16, 2026. Author: GridBelt team.

In these programs

  • Excel test in 7 days, Level 3 planDay 5
  • Excel for Data AnalystsDay 9
  • Excel for Sales and MarketingDay 8

Related exercises

  • INDEX and MATCH exact lookupIntermediate, ~6 min
  • Pick the month column with MATCHIntermediate, ~7 min
  • Last order date per customerExpert, ~10 min
  • Two-criteria lookup (product and region)Expert, ~10 min

Function reference

Official documentation

Next exercise

Last order date per customer