Skip to content

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

Lesson 2/5

VLOOKUP with ranges of values

Exercise 1 of 4

Discounts start at the amounts in column A. In E2, look up the discount for the order in D2.

About this lesson

With an approximate match, VLOOKUP finds the band a value falls into, such as a discount level.

In this lesson

  1. Discounts start at the amounts in column A. In E2, look up the discount for the order in D2.
  2. The order in D2 is now 1,200. In E2, look up its discount.
  3. In E2, look up the grade for the score in D2.
  4. Why must column A be sorted from small to large for an approximate VLOOKUP?

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 E2 and press Enter to check.