HLOOKUP: 10 Different Examples

The HLOOKUP function is solely focusing on performing a horizontal lookup. It is doing it by searching for an inputted value in only top row of a table, and then return that value in the very same column, using the index number that was inputted.

Knowing the Parameters

The HLOOKUP function has different parameters that make it work as a whole, and these parameters are value, array of the table, and then the index number.

Value: This is the value that are searched for in the very first row of the table's array. The value is chosen by the person using it.

Table Array: This can be either two or more rows of the data that has been sorted in an order that is ascending.

Index Number: This is where the user can put in a row number in the array of table, using the data from which a matching value must then be returned. The first row in this is 1.

Example 1: Look for Price Horizontally with HLOOKUP

In this example, we have laid out the price in a horizontal form, and we do not know the price of motorcycle, so we decide to use the HLOOKUP function in Excel to find out the price.

Look for Price Horizontally with HLOOKUP

Example 2: Finding Price Vertically with HLOOKUP

In this example, we have already established a business, and our products' prices have been dynamic. We'd know how many times we have changed the prices. Now, we want to know how much our customers paid for purchasing a car, when we changed the price for a second time.

Finding Price Vertically with HLOOKUP

Example 3: HLOOKUP Finds Email Address

We have a lot of employees/customers, and we would like to find the email address of one of them. We'd know the name of the person, but we do not know his or her email address, and we do not write the employees/customers' names in the same column, but we'd spread them out. This is another place HLOOKUP can be a very handy function in Excel, even though they are other functions that could do the same thing.

HLOOKUP Finds Email Address

Example 4: Locating how Much a Customer Owns

In this example, we'd have many customers, but some of them are owing the company money. We'd know the name of the person, but we do not know the amount that the person is owning. In this circumstances, we are using HLOOKUP function to find the amount of money that Charles is owning.

Locating how Much a Customer Owns

Example 5: Did Anybody Paid in 500?

We have understanding that there have been information about different income into the company, but there is a little misunderstanding. We'd have 500 in the account, and we do not know if it was paid by a customer or if someone else have paid the money, which lead to us looking for it with the help of HLOOKUP function. We'd go to the Excel, where customers' payments are saved. It is important that we are looking for is on top, otherwise the function would not work.

Did Anybody Paid in 500

Example 6: Dealing With the Name Error

There will be circumstances, where the name error is visible on the Excel, but this is not something that should cause any alarm. The reason that the error exists is that we do not add symbol "" to the name. In this example, the only thing needed is just to add the "" to the name (one (") in the beginning of the name, and the second (") would be right after the name).

Dealing With the Name Error

Example 7: How to Deal with N/A Error

In this example, we will look into the possibility of N/A error showing when using the HLOOKUP function, and how we will easily deal with it. In the error, there are many reasons these errors could be showing, it could be that what we are looking for is not in the file, but it can also be that the term is not in the first role, which is where the HLOOKUP function firstly used to do everything it needs to do. One of the best way to deal with this is to look for something that is in the first row, and if what you are looking for is not in the Excel spreadsheet, then it is not necessary for it to be a problem.

How to Deal with NA Error

Example 8: Locating Employees' Telephone Number

In this example, we'd have ten employees, but we'd like to rather use the HLOOKUP function, to simplifies and get the accurate telephone number of the employee, without any risk of getting the telephone number wrong. We have used the HLOOKUP to find the telephone number to the employee, whom we are looking for.

Locating Employees Telephone Number

Example 9: Finding Address to Employee

In this example, we need to send out paycheck for a specific employee who did not get her paycheck, because she was on vacation. This is where the HLOOKUP function can be useful among other functions that Excel have provided.

Finding Address to Employee

Example 10: Confirming Payment

With this function, it is very easy to know if there is a specific value under a name, under the circumstances of having a customer who said that he has paid an amount, but the timing were too close, and the customer have gone from one employee to the other. The customer says that he paid too much, and we would like to confirm it, so we could pay back the money to the customer. This is one of the places, where HLOOKUP is very useful, under certain circumstances, because VLOOKUP function might be more appropriate under other circumstances.

Confirming Payment