Lookup & Reference
MATCH
Returns the relative position of an item in a range that matches a specified value.
Syntax
MATCH(lookup_value, lookup_array, [match_type])Usage Examples
See how this formula can be used in real-world scenarios, generated by AI.