Skip to content

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

Lesson 3/5

HLOOKUP: tables that run across

Exercise 1 of 2

This table runs across: sizes in row 1. In B6, look up how many items of the size in B5 are in stock.

About this lesson

HLOOKUP does what VLOOKUP does, for tables that run across with their labels in the top row.

In this lesson

  1. This table runs across: sizes in row 1. In B6, look up how many items of the size in B5 are in stock.
  2. In B6, look up the price for the size in B5.

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