VLOOKUP

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

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