Excel Match Function - Another Lookup Function

Excel Match function is another lookup function that can use to find out the position of an item in a range. Below data represent the type of mobile phone using by the managers of ABC company.

Pone Type Count
Samsung 35
Sony 30
Sony Ericsson 12
Nokia 28
HTC 15
Blackberry 5

1. Copy above data to your excel sheet or download the file here.
2. Enter "=match(" to the cell D1
3. Then Enter lookup value (30 for this example)
4. Then enter lookup array which you want to search your lookup value
5. Here our count data are in the column B & select B2:B7 range as lookup range
6. Then excel ask for the match type. There are 3 types of matches in excel
   1. Exact match
      1. Excel finds the exact lookup value from lookup array
      2. The array can be any order
   2. Less than match
      1. Excel finds the largest value less than to the lookup value.
      2. The array must be in ascending order
   3. Greater than match
      1. Excel finds the smallest value that is greater than to the lookup value
      2. The array must be in descending order
7. Finally Enter the match type you want and close the function.
8. If you use the exact match you will receive the value 2