How to use Excel HLOOKUP function
How to use Excel HLOOKUP function
HLOOKUP function (MS EXCEL)
What is H LOOKUP?
HLOOKUP stand for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column.
While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.
Syntax
=HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
Example.
Do the following steps
1st Step
Enter your Data in EXCEL WORKSHEET.
Example.
While VLOOKUP searches for the value in a column, HLOOKUP searches for the value in a row.
Syntax
=HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])
Example.
1st Step
Enter your Data in EXCEL WORKSHEET.
Example.
2nd Step
Enter HLOOKUP function
Press enter.
And if you want to DRAG this function. Then you can do.
But if you have error like that
For Example.
THIS IS THE PROBLEM OF TABLE ARRAY
YOU CAN FIX THE TABLE ARRAY
YOU CAN ALSO DRAG THIS FORMULA.
Comments
Post a Comment