Excel FunctionsLesson 93Free preview

MATCH

This lesson is part of Excel · All levels

Summary

MATCH is an Excel function that returns the position of a value in a range. The syntax is. The match_type argument is 0 for the exact search, 1 for the smallest largest value, and -1 for the smallest largest value.

Key points

Syntax: MATCH(kunci, rentang_kunci, [jenis_kecocokan])
Match_type 0 means exact search, most often used
The MATCH results are position numbers, not values.
The exact search range doesn't need to be sorted

Full lesson

Code examples and quizzes

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