Use HLOOKUP when you need to find things in a table or a range by column. It is part of the lookup and reference functions of Excel .
We have prepared a tutorial on the HLOOKUP function to explain it in a bit more detail.
The syntax of the function is the following:
HLOOKUP(lookup_value, lookup_array, row_num, [match_type])
lookup_value : The value that you want to match in lookup_array.
lookup_array : The range of cells being searched.
row_num: The row number containing the return value
match_type: Optional. The number 0 (FALSE=Exact Match), or 1 (TRUE=Approximate Match) which is the default value .
The lookup value should always be in the first row in the range for HLOOKUP to work correctly.
You can use the wildcard characters, question mark (?) and asterisk (*), in criteria. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.
Click on the button to practice using this function, with the help of our Online Assessment Tool:
Here is an example of how to use the HLOOKUP function:
Display the representative of the Della company in the cell B8 of the hlookup workbook using the hlookup function. Representatives of companies are displayed in the SALES worksheet. Then reproduce the function up to the cell G8.