HLOOKUP Excel Formula


Home >> How to Use Excel Tutorial >> Excel Formulas List >> HLOOKUP Excel Formula



In this tutorial, you will learn how to use the HLOOKUP excel formula. The use of h look up excel function is needed when you want to find data in a cell range horizontally. This formula should be understood because data lookup is one of the most important processes in processing data.


Why do We Need to Learn HLOOKUP Formula in Excel?


In processing data on a spreadsheet file, finding data is one of the most often processes done. Usually, there are reference tables from which contents are needed in various parts of our data processing. When we need the contents of the reference tables, then we need to do the lookup process.

Sometimes, this process needs to be done horizontally. This means the data is searched from the perspective of columns in our reference table. To make it not troublesome to get the result, it is better we understand how to automatically do it. The automatic approach should also give more guarantee to the accuracy of the process results.

One work case for the lookup process need is when we want to find particular information about a company’s product. Maybe we need it for production process specifications or product development needs. If we know the variable name and the product row in the reference table, then we should do the lookup horizontally.

Maybe we can do it manually. But, if there are many product variable columns in the reference table, then the process will be troublesome and long.

To help to get your result, you can use the HLOOKUP excel formula. It is an automatic formula that will make your work process much easier when it is needed to be used. HLOOKUP excel formula is important to understand especially if you often need to lookup data horizontally.


What is HLOOKUP Meaning?


HLOOKUP definition is a formula in the spreadsheet file to help finding data in a cell range horizontally. HLOOKUP function in excel is an alternative function available to use for a data lookup process in the spreadsheet.

Generally, the input of this formula can be explained briefly as follows:


=HLOOKUP(lookup_value, table_array, row_index_num, range_lookup)


Notes:
  • lookup_value = reference value to be searched in the first row of your reference table
  • table_array = your reference table cell range
  • row_index_num = the order position of the row on the reference table from where the result of the formula will be taken (the order will be counted from the most top position)
  • range_lookup = optional. Determines whether lookup value will be searched exactly or approximately. TRUE for approximate and FALSE for exact



How to Use HLOOKUP Excel Formula?


The following will explain how to use the HLOOKUP excel formula step-by-step. Each step of using the VLOOKUP excel formula will be explained using the HLOOKUP example in the form of screenshots. This is so the explanation can be easier for you to understand.


Step-by-step HLOOKUP Tutorial

  1. Type equal sign ( = ) in the cell where you want to put the result

    HLOOKUP Excel Formula - Screenshot of Step 1

  2. Type HLOOKUP (can be with large and small letters) and open bracket sign after =

    HLOOKUP Excel Formula - Screenshot of Step 2

  3. Input the lookup value or cell coordinate where the lookup value is to be searched later in the reference table. Then, type a comma sign ( , )

    HLOOKUP Excel Formula - Screenshot of Step 3

  4. Drag cursor on the cell range where your reference table is then type a comma sign. Later, the lookup value inputted earlier will be searched in the first row of this reference table

    HLOOKUP Excel Formula - Screenshot of Step 4

  5. Input the nth order of the row where your lookup result should be found in your reference table. The result will be gotten from where the column in which your lookup value is found combined with this row. If there is more than one fits found for the lookup value, it will get the one on the most left

    HLOOKUP Excel Formula - Screenshot of Step 5

  6. Optional: To determine whether lookup value must be found exactly or just approximately, do this. Input a comma sign and type TRUE/FALSE (can be with large and small letters). TRUE for approximate and FALSE for exact. The definition of approximate is if there is no exact similar value, then it will do this. It will make the smaller nearest value from the lookup value in the reference table’s first row as a reference. As an important note, you must sort the value in the first row in ascending order so the TRUE functions correctly. If there is no input from you in this part, then the input will be assumed as TRUE

    HLOOKUP Excel Formula - Screenshot of Step 6

  7. Type close bracket sign

    HLOOKUP Excel Formula - Screenshot of Step 7

  8. Press Enter
  9. The process is done!

    HLOOKUP Excel Formula - Screenshot of Step 9



Exercise


After learning the step-by-step of how to use the HLOOKUP excel formula, now is the time to do an exercise. It is done so you can deepen your understanding of how to use the HLOOKUP excel formula.

Download the exercise file of the HLOOKUP excel formula below and answer all the questions. Download the answer key file if you have done the exercise and want to check your answers. Or probably you are confused about how to answer all the questions.

Link to the exercise file:
Download here

Questions

Answer each question with the HLOOKUP excel formula in the appropriate gray-colored cells!
  1. What is the number in column E on the row marked with 6?
  2. What is the number in column C on the row marked with 1?
  3. What is the number in the column with the number close to 60000 on the row marked with 5? Find it in the row marked with 10

Link to the answer key file:
Download here


Additional Notes

  • If you need to find data vertically, then you need to use the VLOOKUP formula instead. Learn the way to use it here!
  • If you want to find data more flexible horizontally or vertically, then you need to learn the INDEX MATCH combination. Learn it by reading this Compute Expert tutorial!




Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on


CONTACT US PRIVACY POLICY TERMS AND CONDITION AFFILIATE DISCLOSURE @Compute Expert