Learn How to Get Information Corresponding to Max Value in Microsoft Excel
The main purpose of this formula is to lookup information related to the maximum value in a range. Here we will learn how to get information corresponding to the maximum value in the given data range in the workbook in Microsoft Excel.
That implies, with the help of a formula based on the MAX, INDEX, and MATCH functions, you can able to lookup information related to the maximum value in a range.
So, with the help of this formula, you can able to get information corresponding to the maximum value in the given data range in the workbook in Microsoft Excel.
General Formula to Get Information Corresponding to Max Value
=INDEX(range1,MATCH(MAX(range2),range2,0))
The Explanation to Get Information Corresponding to Max Value
So we know that with the help of the given formula above, you can able to lookup information related to the maximum value in a range. Here we will learn how to get information corresponding to the maximum value in the given data range in the workbook in Microsoft Excel.
As we know that in the 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.
So now you have learned how to get information corresponding to the maximum value in the given data range in the workbook in Microsoft Excel.