What will the function given below return in MS-Excel 2010?

`=MATCH(12,{10,13,30,40,60},1)`

Question

What will the function given below return in MS-Excel 2010?

`=MATCH(12,{10,13,30,40,60},1)`

Accepted Answer

**Solution:**

1. The syntax of the MATCH function is:
   
   ```
   MATCH(lookup_value, lookup_array, [match_type])
   ```

2. Here, the parameters are:
   - *lookup_value* = 12
   - *lookup_array* = {10, 13, 30, 40, 60}
   - *match_type* = 1

3. When *match_type* is 1, MATCH finds the largest value in the array that is less than or equal to the *lookup_value*. The array must be sorted in ascending order for this to work correctly.

4. The values in the array are: 10, 13, 30, 40, 60.

5. Among these, the values less than or equal to 12 are only 10.

6. The largest such value is 10, which is at position 1 in the array.

7. Therefore, the function returns 1.

**Answer:** 1

Answer

Answer

Answer