Skip to main content

VLOOKUP

Returns the value of a cell within a specified cell range in a choosen row and characteristic.

Syntax

=VLOOKUP(Value, Table, Col_Index [, Range_Lookup])

Arguments

NameDescription
ValueThe value to look for in the first column of a table.
TableRange to look in. The table from which to retrieve a value.
Col_IndexThe column in the table from which to retrieve a value.
Range_LookupOptional TRUE = approximate match (default). FALSE = exact match.

Return Value

Value of cell within the given range and index or offset, if a row with the value was found.

Example

FunctionResultComment
=VLOOKUP("Test3",A2:B4, 2)

3The value of cell B3 within the given range is returned.