1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel HLOOKUP Step by Step Tutorial

By

1 of 9

How to Use HLOOKUP in Excel
How to Use HLOOKUP in Excel

How to Use HLOOKUP in Excel

© Ted French

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

©2014 About.com. All rights reserved.