Excel Practice - VLOOKUP
Instruction
Use VLOOKUP to find a product price based on product code.
Formula Syntax
=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
- lookup_value: The value to find.
- table_array: The table range that contains lookup data.
- col_index_num: The return column position in the table (starting at 1).
- [range_lookup]: Optional match mode: FALSE for exact match, TRUE for approximate match.
What it does
Use VLOOKUP to find a product price based on product code.
product-catalog.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 VLOOKUP 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.