How to use hlookup in excel (Examples, Guide)

July 26, 2022
1.2K Views
0

A free Office suite fully compatible with Microsoft Office

HLOOKUP, which stands for horizontal lookup, can be used to extract data from a database by looking for matching information in a row and then printing it in the corresponding column. HLOOKUP looks for the value in a row, while VLOOKUP looks for the value in a column.

Formula:

=HLOOKUP(value to look up, table area, row number)

How to use the hlookup function in excel online, 2016 and 2019:

Consider the following example. Following are the grades for five students in four subjects:

Now, if our goal is to retrieve the management grade for student D, we may utilise HLOOKUP as follows:

The Excel HLOOKUP function accepts the following arguments:HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])We must first provide the lookup value, as seen in the screenshot above. Student D in this instance, as we need to find his Management grade points. Now keep in mind that lookup value can also be a number value in addition to a cell reference or text string. In our case, the student name would be as follows:

Giving the table array would be the following step. Rows of data are all that a table array is, and this is where the lookup value would be looked up. Table arrays can be Excel tables or ordinary ranges with names. As a reference, we will use rows A1 through F5.

The row number in the table array from which the value will be returned is defined as row index num next. As we are retrieving the value from the fourth row of the provided database, the answer in this instance would be 4, thus.

Consider setting row index num to 3 if we wanted to demand marks in Economics.Range lookup is the following. It causes HLOOKUP to look for a precise or close value. Since we're seeking for a precise value, False would be the answer.

The result would be 72.

In this case, HLOOKUP looks up a certain value in the table and returns an exact or close value.Important considerations regarding HLOOKUP in excel:A case-insensitive lookup is used. For instance, it will treat TIM and tim as synonyms.When using HLOOKUP, the Lookup value column should be the first row of the table array. A different Excel formula must be used if we need to look in a different place.Wildcard characters like * and ? are supported by HLOOKUP in the lookup value parameter (but only if lookup value is text).Note: This above written article is an attempt to show you how to use hlookup in excel online, 2016 and 2019, in both windows and mac.You just need to have a little understanding of how and which way things work and you are good to go. With having this basic knowledge or information of how to use it, you can also access and use different other options on excel or spreadsheet. Also, it is very similar to Word or Document. So, in a way, if you learn one thing, like Excel, you can automatically learn how to use Word as well because both of them are very similar in so many ways. If you want to know more about WPS Office, you can download WPS Office to access, Word, Excel, PowerPoint for free.