This article describes the formula syntax and usage of the HLOOKUP function in Microsoft Excel. Description Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array.

Use VLOOKUP, HLOOKUP, and other functions like INDEX and MATCH to search for and find data based on values you enter. This article gives you a quick VLOOKUP refresher, then links to more.

To do this task, use the HLOOKUP function. Important: Make sure the values in the first row have been sorted in an ascending order. In the above example, HLOOKUP looks for the value 11000 in row 3 in the specified range. It does not find 11000 and hence looks for the next largest value less than 1100 and returns 10543.

You can try out these examples in your own Excel worksheet to learn how the LOOKUP function works. In the first example, you're going to end up with a spreadsheet that looks similar to this one:

Excel comes with multiple Lookup and Reference functions that let you find matching values. Use this article to decide which function is best for your needs.

This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get the same result.

Worksheet functions are categorized by their functionality. Click a category to browse its functions. Or press Ctrl+F to find a function by typing the first few letters or a descriptive word. To get detailed information about a function, click its name in the first column.

When you create a VLOOKUP or HLOOKUP function, you enter a range of cells, such as D2:F39. That range is called the table_array argument, and an argument is simply a piece of data that a function needs in order to run.

By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument that instructs the function to find an exact match even if the table is not sorted.

Find Microsoft Excel help and learning resources. Explore how-to articles, guides, training videos, and tips to efficiently use Excel.