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