VLOOKUP
Searches for a value in the first column of a table and returns a value in the same row from another column
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Parameters
- lookup_value: Required. The value to search for in the first column of the table
- table_array: Required. The range of cells that contains the data
- col_index_num: Required. The column number in table_array from which the matching value must be returned
- range_lookup: Optional. TRUE for approximate match (default), FALSE for exact match
Example
=VLOOKUP("Smith", A2:D20, 3, FALSE)