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. 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.