Excel Practice - HLOOKUP
Instruction
Find "P-102" in the top row of A1:C6 and return the value from the 3rd row with exact match.
Formula Syntax
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
- lookup_value: The value to find.
- table_array: The table range that contains lookup data.
- row_index_num: The return row position in the table (starting at 1).
- [range_lookup]: Optional match mode: FALSE for exact match, TRUE for approximate match.
What it does
Lookup a value across the top row of a table.
lookup-reference-table.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Code | Name | Price |
| 2 | P-101 | Mouse | 19 |
| 3 | P-102 | Keyboard | 45 |
| 4 | P-103 | Monitor | 199 |
| 5 | P-104 | USB Hub | 29 |
| 6 | P-105 | Headset | 59 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use HLOOKUP with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.