By Ted French
Using the Excel HLOOKUP Function
Related tutorial: Excel HLOOKUP Function Step by Step Tutorial.
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.