Course contents · Lookup functions

HLOOKUP

Open the practice in the trainer →

HLOOKUP performs a horizontal lookup: it searches for a value in the top row of a table and returns the value in the same column from the row with the given index.

=HLOOKUP(value, table, index_number, [approximate_match])

Use it when the lookup table is horizontal: months, years or positions are column headings.

The manual notes: the row/column index is better calculated with MATCH than typed by hand — then the formula won't break when rows are rearranged.

Tasks in the trainer

  1. In B7:B9 look up the salary by position from the table A1:E4.
  2. In C7:C9 — leave days, in D7:D9 — company car.
  3. In E7:E9 calculate the annual salary (salary × 12).
  4. In C12 look up parameter B12 for position A12: get the row number with MATCH over A1:A4.
  5. In B14 count how many positions come with a company car.

Solve the tasks in the trainer →

Check yourself

  1. Where does HLOOKUP search for the value?