VLOOKUP function
Looks in the first column of an array and moves across the row to return the value of a cell
Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| lookup_value | Yes | The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument.B2 |
| table_array | Yes | The range of cells in which the VLOOKUP will search for the lookup_value and the return value. You can use a named range or a table, and you can use names in the argument instead of cell references. C2:E7 |
| col_index_num | Yes | The column number (starting with 1 for the left-most column of table_array) that contains the return value.1 |
| range_lookup | No | A logical value that specifies whether you want VLOOKUP to find an approximate or an exact match: Approximate match - 1/TRUE, Exact match - 0/FALSETRUE |
Try VLOOKUP
Look up a region in a two-column table
=VLOOKUP("Cedar",B2:C5,2,FALSE)Look up a region in a two-column table. The result is checked against a separately authored expected value for the supplied table. You can edit the data to explore the rule.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
VLOOKUP · top-level call
=VLOOKUP("Cedar",B2:C5,2,FALSE)1 / 4 · lookup_value
The value you want to look up. The value you want to look up must be in the first column of the range of cells you specify in the table_array argument.
VLOOKUP reference ↗Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.