The HLOOKUP function in Excel is responsible for **search and find a value in a range of cells**. However, its search is done horizontally through the rows, therefore, it has an “H”.

In this article we will explain **how to use the HLOOKUP function in Excel** quickly and easily. In this way, you will be able to carry out immediate searches that will optimize the results.

## Syntax

The HLOOKUP function in Excel has the following arguments:

**search_value**: is a mandatory element since it is used to search for the desired value. This value can be a cell reference, a text string (it must be written in quotes) or a number.**Array_search_in**: It is also a mandatory field in which the data is searched. Typically, a range of cells or their name is used.**row_indicator**: in this element you must indicate in which row the result you want to obtain is located, for example, if the result is in the seventh row, the indicator will be “7”.**Tidy**: is the element that will specify whether the formula should search for an exact or approximate value. If you want an exact result to be found, write “FALSE”, otherwise write “TRUE” to get an approximate value.

**Note**: It is worth mentioning that the HLOOKUP function in Excel is the same as the HLOOKUP function, but in English. You can use it in the same way, what will vary is the name of its arguments.

## How to use the HLOOKUP function in Excel?

The HLOOKUP function in Excel will be used to find an email from a contact list using its ID number. To do this you just have to do the following:

- Enter the data into the Excel sheet. Now, in a blank cell write “
**=HLOOKUP(**”. - In this case, in “
**search_value**”**a cell will be clicked**to be a reference. A comma will be added to continue with the next argument. - In “
**array_search_in**”, select the search range. To do this, click and hold from the first cell to the last to complete the box. In this case the range is “A2:F4”. - In “
**row_indicator**”, write the number of the row where you want to obtain the result. In this case, you want to know the name of the product, therefore it will be row 3. - Now in “
**tidy**”, choose “TRUE” to obtain an approximate result or “FALSE” to obtain a result. - Close parentheses and press “
**Enter**”.

**Note**: This process is the most automated since, if you change the data in the reference cell, the result of the formula will automatically change.

## Aspects to consider

If you use the HLOOKUP function in Excel, you must take the following aspects into account:

- The “#N/A” error appears if the function
**does not find an exact match**by entering “FALSE”. - If HLOOKUP does not find the searched value and the “sorted” argument is true, then it will use the largest value that is less than the searched value.

As you have seen, the process to use the HLOOKUP function in Excel is simple.