The VLOOKUP function searches for a value in the first column of a table array and returns a value in the same row from another column. The basic syntax for VLOOKUP is:
- lookup_value: The value you want to search for. - table_array: The range of cells that contains the data. - col_index_num: The column number in the table array from which to retrieve the value. - range_lookup: Optional; TRUE for an approximate match, FALSE for an exact match.