Excel Practice - INDEX MATCH
Instruction
Combine INDEX and MATCH to return the department for employee ID 1003.
Formula Syntax
=INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
- return_range: The range/array that returns the matched result.
- MATCH(lookup_value: The value to find.
- lookup_range: The range/array used for lookup.
- 0): Function input parameter.
What it does
Combine INDEX and MATCH to return the department for employee ID 1003.
employee-table.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | ID | Name | Department |
| 2 | 1001 | Liam | Design |
| 3 | 1002 | Mia | Sales |
| 4 | 1003 | Noah | Finance |
| 5 | 1004 | Olivia | Support |
| 6 | 1005 | Paul | Engineering |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use INDEX.MATCH 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.