VLOOKUP

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

Syntax

=VLOOKUP(Value, Range, Index [, ExactMatch])

Arguments

NameDescription
ValueValue to look up in the first column of the given range.
RangeRange to look in.
IndexRelative index to the column of the identified row, to retrieve the return value from.
ExactMatchOptional. A value to specify exact or approximate match with wildcards. Specify TRUE for an approximate match, FALSE for an exact one. Default is TRUE.

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.