Skip to content

Lessons in your language are coming soon. Formulas already work in your Excel language.

Lesson 4/5

XLOOKUP: the modern lookup

Exercise 1 of 4

In F2, look up the price for the code in E2 with XLOOKUP.

About this lesson

XLOOKUP searches one range and returns the matching item from another, in any direction, with an exact match by default.

In this lesson

  1. In F2, look up the price for the code in E2 with XLOOKUP.
  2. In F2, find the code for the product name in E2. The code column is to the left of the names.
  3. The code in E2 doesn't exist. In F2, look up its price, but show "not found" instead of #N/A.
  4. What can XLOOKUP do that VLOOKUP can't?

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.