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
Post a Comment