# Learn How to Get Information Corresponding to Max Value in Microsoft Excel

Written by | 0 Comments | 271 Views

In this article, you will learn how to evaluate things based on the LOOKUP function in Microsoft Excel using a single/combination(s) of functions. You will also know to Get Information Corresponding to Max Value and see the generic formula.

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.