Match function returns the position of a value in an array.
Syntax of Match Function
=Match(lookup_value, lookup_array, [match_type])
lookup_value = The value you want to find in the list.
lookup_array = List in which you want to find the value.
[match_type] = Match type can be -1, 0 or 1.
-1 finds the smallest value greater than or equal to look up value.
0 finds the exact equal value to lookup value.
1 find the largest value less than or equal to lookup value.
In the above screen shot, Match function would return 3 in the Cell C4. 3rd is the position of Gurgaon (lookup value) in the list B7:B13.