HLOOKUP Function Explained
The HLOOKUP Function in Microsoft Excel is used to search for a value in the top row of a table or range of cells and return a value in the same column from a row you specify. It takes four arguments: lookup_value, table_array, row_index_num, and range_lookup. The lookup_value is the value to search for in the top row of the table. The table_array is the range of cells that make up the table. The row_index_num is the row number in the table from which the matching value should be returned. The range_lookup is a logical value that specifies whether you want an exact or approximate match.
HLOOKUP Function Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
- lookup_value: The value to search for in the first row of the table array.
- table_array: The range of cells that make up the lookup table.
- row_index_num: The row number in table_array from which the matching value must be returned.
- range_lookup: (Optional) A logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match: TRUE for approximate match and FALSE for exact match.