1. Computing

Excel HLOOKUP Function

By

1 of 4

Using the Excel HLOOKUP Function
Using the Excel HLOOKUP Function

Using the Excel HLOOKUP Function

© Ted French

Using the Excel HLOOKUP Function

Related tutorial: Excel HLOOKUP Function Step by Step Tutorial.

Excel's HLOOKUP function, short for horizontal lookup, is used to find specific information that has been stored in a spreadsheet table.

HLOOKUP works much the same the Excel VLOOKUP function, or Vertical Lookup.

The only difference being that VLOOKUP searches for data in columns and HLOOKUP searches for data in rows.

If you have an inventory list of parts or a large membership contact list, HLOOKUP can help you find data that matches specific criteria such as the price of a specific item or a person's phone number.

©2014 About.com. All rights reserved.