HLOOKUP In Excel
HLOOKUP stands for Horizontal lookup.
HLOOKUP is used to search the values in the top row of table array or array of values by column.
HLOOKUP Syntax contains the following:
- lookup_value : The value which you want to lookup.
- table_array : The range in which the lookup value is located.
- row_index_num : The row number that stores the return value. For example: the first row in table array represents 1 and the second row in table array represents 2 and so on.
- range_lookup : Optionally, you can specify TRUE for approximate match and FALSE for exact match.
Together, we put all of the above:
=HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
Examples Of HLOOKUP :-
In above examples we find the EMP NAME by EMP ID using HLOOKUP.
In above examples we find the SALARY by EMP ID using HLOOKUP.
The result is as follows:-