# Related info for max value in range ### Related Functions

`=INDEX(range1,MATCH(MAX(range2),range2,0)`

To lookup information related to the the maximum value in a range, you can use a formula that comines the MAX, INDEX, and MATCH functions.

In the example shown, the formula in I8 is:

`=INDEX(F3:F11,MATCH(MAX(C3:C11),C3:C11,0))`

Which returns the number 4004, representing the square footage (Sq. Ft.) of the most expensive property in the list.

### How this formula works

The MAX function first extracts the maximum value from the range C3:C11.

In this case, that value is 820000.

This number is then supplied to the MATCH function as the lookup value. The lookup_array is the same range C3:C11, and the match_type is set to “exact” with 0.

Based on this information, the MATCH function locates and returns the relative position of the max value in the range, which is 9 in this case.

The number 9 is supplied to INDEX as “row number” along with the range F3:F11, supplied as the lookup array. INDEX then returns the value in the 9th position in F3:F11 which is 4004.

Note: in case of duplicates (i.e. two or more max values that are the same) this formula will return info for the first match, the default behavior of the MATCH function.

### 0 votes. 0 / 5 .rate-title { display: none; } .rating{ padding-right: 10px; } .ratingthis{ display: -webkit-inline-box; color:#444; font-weight: bold; } 