VLOOKUP

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

Syntax

=VLOOKUP(Value, Table, Col_Index, Range_Lookup)

Arguments

Name	Description
Value	The value to look for in the first column of a table.
Table	Range to look in. The table from which to retrieve a value.
Col_Index	The column in the table from which to retrieve a value.
Range_Lookup	Optional TRUE = approximate match (default). FALSE = exact match.

Return

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

Examples

Formula	Result	Comment
=VLOOKUP("Test3",A2:B4, 2)	3	The value of cell B3 within the given range is returned.