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 | Type | Description |
|---|---|---|
| Value | Number | The value to look for in the first column of a table. |
| Table | Range | Range to look in. The table from which to retrieve a value. |
| Col_Index | Number | The column in the table from which to retrieve a value. |
| Range_Lookup | Number | Optional TRUE = approximate match (default). FALSE = exact match. |
Return
| Type | Description |
|---|---|
| Number | Value of cell within the given range and index or offset, if a row with the value was found. |
Examples
| A | B | |
|---|---|---|
| 1 | Test1 | 3 |
| 2 | Test2 | 4 |
| 3 | Test3 | 3 |
| Formula | Result | Comment |
|---|---|---|
| 3 | The value of cell B3 within the given range is returned. |