Using the Excel HLOOKUP Function
Related article: Excel 2007 HLOOKUP Function.
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.
