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])
- value — what to search for in the first column;
- table — two or more columns (lock it with
$); - index_number — which column to return, the first column is 1;
- approximate_match —
FALSEfor an exact match;TRUE(default) for an approximate one, then the first column must be sorted ascending.
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.