VLOOKUP
Description
Finds a value in the leftmost column of the specified array, and returns the value
for the corresponding cell in the same row in a different column.
Syntax
VLOOKUP(
lookup_value
,
table_array
,
col_index_num
, [
range_lookup
])
- lookup_value: The value to find in the first column.
- table_array: The array or table to search.
- col_index_num: The column to return the corresponding value from.
- range_lookup: Specifies whether to require an exact match. FALSE = return an error if the function doesn't find an exact match; TRUE or Empty = if the function doesn't find an exact match, use the closest match below the lookup_value as a match.
Related Functions
ARRAYAREA
GROUPBY
MATCHEXACT
MVLOOKUP