Match Function

Match function looks for a value in a given range and returns the relative position of that value.

Syntax: =Match(lookup value, Lookup array, match type)

Lookup value = The value you want to find in the array

Lookup Array : The range where the lookup value is searched

Match type: This argument specifies whether to look for exact match or near match

                Match type 0 will look for exact match and return the position

                Match type 1 will look for a value that is less than or equal to the lookup value.

                Match type -1 will look for a value that is greater than or equal to the lookup value.

To understand this look at the below table of values.

Look at the below match functions with different arguments and the returned values