VLOOKUP
Looks in the first column of an array and moves across the row to return the value of a cell.
Lookup & ReferenceBeginner EssentialsLookup & Matching EssentialsMost Used
What it does
Searches the first column of a table and returns a value from a specified column in the same row.
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Arguments
lookup_value(value) — Value to find in the first column of table_array.table_array(range) — Table containing the lookup column and return column.col_index_num(number) — Column number in table_array to return from (1-based).
Examples
Exact match lookup
Find the Price for a product code.
FORMULA
=VLOOKUP(A2,B2:C5,2,FALSE)
RESULT
9.99
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Code to find | Code | Price |
| 2 | P2 | P1 | 4.99 |
| 3 | P2 | 9.99 | |
| 4 | P3 | 7.5 | |
| 5 | P4 | 12 |