Skip to content
Lesson 4/4

XMATCH

Exercise 1 of 3

In F2, find the position of the code in E2 with XMATCH.

About this lesson

XMATCH is the modern MATCH: exact by default, and it can search from the end of a list.

In this lesson

  1. In F2, find the position of the code in E2 with XMATCH.
  2. In F2, look up the price for the code in E2 with INDEX and XMATCH.
  3. In D2, find the position of the last order from the region in C2, within the list A2:A9.

Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.

fx

Type in F2 and press Enter to check.