Loading…
Loading…
VLOOKUP looks down the first column of a table and returns a value from another column.
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
| Argument | Required? | What it is |
|---|---|---|
| lookup_value | Required | The value to look for, such as an ID or name. |
| table_array | Required | The table to search. The value you look for must be in its first column (or row for HLOOKUP). Lock it with $. |
| col_index_num | Required | Which column of table_array to return, counting the first column as 1. |
| range_lookup | Optional | FALSE (or 0) for an exact match, which you almost always want. TRUE finds an approximate match in sorted data. |
=VLOOKUP("P102",A2:D6,3,FALSE) returns the price of P102.
From the lesson VLOOKUP Function.
Type the formula yourself and get it graded instantly, no Excel needed.