excel+courses - Match function

Hello Sasha

Thank you for your question

The match function simply searches through an array of data and returns the relative postion of an item that matches a particular criteria.

It has the following syntax

MATCH(lookup_value,lookup_array,match_type)

The lookup value is the criteria you are searching on

Lookup Array is the range of the array you are searching

Match type is either 1,0 or -1

1 finds the smallest value that is less than or equal to the criteria. The array must be sorted in ascending order

0 finds the first value that is exactly equal to the criteria

-1 finds the largest value that is greater than or equal to the criteria. Here the array must be sorted in descending order


Hope you're well

Regards

Stephen