Course contents · Lookup functions

VLOOKUP

Open the practice in the trainer →

VLOOKUP performs a vertical lookup: it searches for a value in the first column of a table and returns the value in the same row from the column with the given index.

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

Example from the manual: find the salary for each cadre in a lookup table and calculate the budget per branch.

Approximate lookup is useful for scales: tax brackets, volume discounts, grades by score.

Tasks in the trainer

  1. In C2:C6 look up the salary by position in the table G2:H5 (exact match).
  2. In E2:E6 look up the bonus percentage on the scale G8:H11 (approximate match).
  3. In F2:F6 calculate the bonus amount = Sales × Bonus, %.
  4. In C7 — total salaries.
  5. In B9 look up the salary for the position in A9; if it is not in the table, return “Not found”.

Solve the tasks in the trainer →

Check yourself

  1. Which fourth argument gives an exact match?
  2. VLOOKUP returned #N/A. The most likely reason?
  3. Why can’t VLOOKUP return a value from a column to the left of the lookup column?