Excel MATCH Function
Syntax
=MATCH(lookup_value, lookup_array, [match_type])
Description
Searches for a specified item in a range of cells, and then returns the relative position of that item in the range.
Example Excel File
Enter your email to receive the example Excel file (link valid 24h).
Become a supporter
—
download instantly, no email