EXCEL HLOOKUP
The HLOOKUP is used to search for a specific value in the header row of a table (a range of cells) and then return a corresponding value from a specified row in that table.
Syntax :
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Arguments or Parameters:
Lookup_value: Lookup_value specifies the value that we want to look up in the first column of a table.
Table_array: The table array is the data array that is to be searched. The VLOOKUP function searches in the leftmost column of this array.
Row_index_num: This is an integer, specifying the column number of the supplied table_array, that you want to return a value from.
Range_lookup: This defines what this function should return if it does not find an exact match to the lookup_value.
TRUE – Approximate match, that is, if an exact match is not found, use the closest match below the lookup_value.
FALSE – Exact match, that is, if an exact match not found, then it will return an error.
Note: Lookup value Must be the first row of the Table_array.
Objective: Find the EmpName from the EmployeeTable in Column C13 using Code in Column C12
Step 1:
Select cell C13
Type = sign
Type HLookUP
Step 2:
Type C12 in lookup_value argument
Type “,”
Step 3:
Select the Range A1:G7
Type “,”
Step 4:
EmpName is the 2nd row of the Range A1:G7
Select 2 in row_index_num Argument
Type “,”
Step 5:
We are Looking for the Exact Match
Type 0 in [range_lookup] Argument
Close the formula Brack with “)”
Press Enter
Conclusion: The Hlookup has populated Kevin Brown in cell c13.
