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
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
Value of cell within the given range and index or offset, if a row with the value was found.
Example
Function | Result | Comment |
---|---|---|
=VLOOKUP("Test3",A2:B4, 2) | 3 | The value of cell B3 within the given range is returned. |