Excel HLOOKUP Step by Step Tutorial

How to Use HLOOKUP in Excel

Related Tutorial: Text only version - Excel's HLOOKUP Function

Excel's HLOOKUP function, short for horizontal lookup, can help you find specific information in large data tables such as an inventory list of parts or a large membership contact list.

HLOOKUP works much the same Excel's VLOOKUP function. The only difference being that VLOOKUP searches for data in columns while HLOOKUP searches for data in rows.

Following the steps in the tutorial topics below walk you through using the HLOOKUP function to find specific information in an Excel database.

The last step of the tutorial covers error messages that commonly occur with the HLOOKUP function.

Tutorial Topics

• Entering Tutorial Data


• Starting the HLOOKUP Function


• The Lookup Value


• The Table Array


• The Row Index Number


• The Range Lookup


• Using HLOOKUP to Retrieve Data


• Common Error Messages for Excel HLOOKUP

• How to Use HLOOKUP in Excel
• Entering the Tutorial Data
• Starting the HLOOKUP Function
• The Lookup Value
• The Table Array
• The Row Index Number
• The Range Lookup
• Using HLOOKUP to Retrieve Data
• Excel HLOOKUP Error Messages