Excel Hlookup
Hlookup is one of the lookup and reference functions. If you want to find things in a table or a range by colom you can use hlookup function.
For example, look up an student's name by her student number. lookup a grade by her value
Syntax :
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Description:
For example, look up an student's name by her student number. lookup a grade by her value
Syntax :
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Description:
- Lookup_value: The value that is searched for in the first row of the table, can be a number or text.
- Table_array: A table of information where data is searched.
- Row_index_num: The row number in table_array will return the matching value. Row_index_num 1 returns the first row value in table_array, row_index_num 2 returns the second row value in table_array, and so on.
- Range_lookup: A logic value that determines whether you want HLOOKUP to look for an exact match or close match.
Example:
Place your cursor on K2 cell.
Click Formula, and then Insert Function.
The display like that.
On the select category choose Lookup & Reference.
Click HLOOKUP and click OK button.
The Display like that.
Insert Lookup_value column as the value you want to look up.
Insert Table_array column as the range of cells in which the HLOOKUP will search for the lookup_value and the return value.
Insert Row_index_num as the row number that contains the return value.
For example like this:
Click OK button.
The result like this.
If you want to read about Vlookup Function in Microsoft Office Excel, you can click HERE
Insert Row_index_num as the row number that contains the return value.
For example like this:
The result like this.
If you want to read about Vlookup Function in Microsoft Office Excel, you can click HERE
No comments