HLOOKUP stands for ‘Horizontal Lookup’. It is a function in Excel that makes search for a certain value in a row.
HLOOKUP allows you to search a data range that is set up Horizontally. While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.
Syntex
HLOOKUP (lookup_value, table_array, row_index_num, range_lookup)
Arguments
1. lookup_value – The value to look up.
2. table_array – The table from which to retrieve data.
3. row_index – The row number from which to retrieve data.
4. range_lookup – [optional] exact match or approximate match.
Example 1
Example 2
Example 3
