Excel FunctionsLesson 89Free preview

INDEX MATCH

This lesson is part of Excel · All levels

Summary

The combination of INDEX and MATCH replaced VLOOKUP for a more flexible and resilient search. MATCH determines the position of the key value, and then the INDEX takes the result based on that position. The advantage is that it is not tied to the leftmost column and is not damaged when the column is inserted.

Key points

Common syntax: INDEX(kolom_hasil, MATCH(kunci, kolom_kunci, 0))
Matching with argument 0 means exactly searching
You can look left or right freely.
The resulting column and the key column should be along the same row

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.