67. Finding data using HLOOKUP

Finding Data Using HLOOKUP

**HLOOKUP** (Horizontal Lookup) is a function in Excel used to search for a value in the first row of a table and return a value in the same column from another row. It is ideal for horizontal tables where headers are arranged in rows.

Steps to Use HLOOKUP

  • Step 1: Identify the table range that includes the lookup value and the data to return.
  • Step 2: Enter the formula =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup]).
  • Step 3: Specify:
    • lookup_value: The value to search for (e.g., a product name).
    • table_array: The range of the table to search.
    • row_index_num: The row number in the table to return data from.
    • range_lookup: Use FALSE for an exact match.
  • Step 4: Press Enter to display the result.

Interactive Example: Find Data Using HLOOKUP

Product Laptop Tablet Smartphone
Price $1000 $500 $800
Stock 50 30 100

Enter a product name and a row name to find the corresponding data using HLOOKUP.

Comments