How to use Hlookup function on Excel

One of the most commonly used Excel search functions is Hlookup function. Hlookup function basically also has the function syntax and features like VLOOKUP function, which is to help users find data in Excel table, with the conditions or given information.

Both of these functions are Excel basic functions , with simple usage. However, if you use Vlookup function to search for pre-defined conditions by column, Hlookup function will search by line. That is, the user will specify the conditional line in Excel and then use the Hlookup function to find the exact value. When using these two search functions, the column or specified line element that makes good information will play a role in determining the search direction of the function we want to use. Alternatively, you can combine Vlookup and Hlookup functions with other functions to use.

The following article will guide you how to use Hlookup function on Excel.

1. Use VLOOKUP to join two Excel tables together
2. How to combine Sumif and Vlookup functions in Excel
3. Summary of expensive shortcuts in Microsoft Excel

How to use Hlookup Excel function

The syntax of Hlookup function in Excel is

1. = Hlookup (probe value, detector value table, order number, search range)

Inside:

1. Detector value table: Must be in the absolute address (by selecting the table and pressing F4), when choosing not to scan the title.
2. Search scope: If False (0) performs a correct search, True (1) is a relative detection.

We will classify grade point average with the data table below. You will need to use the Hlookup function.

How to use Hlookup function on Excel Picture 1

Step 1:

In the first cell of the Sort column of average grades for students, we enter the input formula in cell C3 as: = HLOOKUP (B3, $ A $ 9: $ E $ 10,2,1) , then press Enter. The number 2 here will be the Sort line in the Excel table with the given condition, 1 will be TRUE relative detection.

How to use Hlookup function on Excel Picture 2

Step 2:

The result then we will be graded for the first student as shown below. The formula has been based on students' average scale and grading criteria for students.

How to use Hlookup function on Excel Picture 3

We pull down the remaining boxes to complete the average score for students.

How to use Hlookup function on Excel Picture 4

Thus, we have instructed you how to use Hlookup function to search data in the table with given conditions and information. The function will return to the user the exact result based on the conditions set. We can also combine Hlookup with SumIf function with Excek tables that require more data filtering skills.

I wish you all success!