Searches for a value in the first column of the specified table or array of values, and returns a value in the same row from another specified column in the table or array.
Syntax
 Copy Code
|
|---|
VLOOKUP( Any lookup, ReferenceOrArray dataSource, Integer column, [Logical rangeLookup = TRUE] ) → Any |
Parameters
- lookup
- Required. The value to search for in the first column of the table. The lookup value can be a value or a reference.
- dataSource
- Required. The table to be looked up. The source can be a reference to a range of cells or an array.
- column
- Required. The column number in dataSource from which the matching value will be returned.
- rangeLookup
- Optional. A logical value indicating whether VLOOKUP should find an exact or an approximate match.
Remarks
If VLOOKUP cannot find lookup, and rangeLookup is TRUE (or omitted), it uses the largest value that is less than lookup. If rangeLookup is FALSE, VLOOKUP will find an exact match. If one is not found, the error value #N/A is returned.
See Also
Function Reference
INDEX Function
MATCH Function
OFFSET Function
HLOOKUP Function