VLOOKUP
Looks up value in first column of range and returns value from specified column.
- Excel: Verified match
- Google Sheets: Verified match
- Returns: Any value
Examples
=VLOOKUP("south", R2:S4, 2, FALSE) | R | S | |
|---|---|---|
| 2 | north | 100 |
| 3 | south | 200 |
| 4 | north | 300 |
Result 200
=VLOOKUP(25, A1:B5, 2, TRUE) | A | B | |
|---|---|---|
| 1 | 10 | 2 |
| 2 | 20 | 4 |
| 3 | 30 | 6 |
| 4 | 40 | 8 |
| 5 | 50 | 10 |
Result 4
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])lookup_value- any required
table_array- range required
col_index_num- number required
range_lookup- boolean optional defaults to
1
Related
ADDRESSReturns a cell address as text from row and column numbers. AREASReturns the number of areas in a reference. HLOOKUPSearches first row and returns matching value. HYPERLINKThe text a link displays: clickability is the renderer's. INDEXReturns value at row and column in range. INDIRECTReturns reference specified by text string.