Excel Formulas to Get Information Corresponding to Maximum Value!!
Tags: excelformula, excelformulas
Published: 2021-01-12 03:52:12

---
title: Excel Formulas to Get Information Corresponding to Maximum Value!!
published: true
date: 2021-01-03 16:08:44 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/get-information-corresponding-to-maximum-value/
---

Assume that you have an employee database, and you need to find the information based on the highest value. In this case, how can you calculate them quickly? Let’s get into this article!! Here, we will guide you to learn the simple formula used to **get the information related to the maximum value in a range in Excel**.  
Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Get information based on maximum value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Get-information-based-on-maximum-value.png)](https://geekexcel.com/get-information-corresponding-to-maximum-value/get-information-based-on-maximum-value/#main)<figcaption id="caption-attachment-20558">Get information based on the maximum value</figcaption>

## Jump To:

- [**Generic Formula**](#1)
- [**Syntax Explanations**](#2)
- [**Example**](#3)
- [**Conclusion**](#4)

## Generic Formula:

- To look up the information related to the maximum value in a range, you can use the below formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(range1,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)(range2),range2,0))**

## Syntax Explanations:

- **INDEX** – It will help to return the value at a given position in a range or array. Read more on the **[INDEX Function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**.
- **MATCH** -The [**MATCH function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) in Excel helps to locate the position of a lookup value in a row, column, or table.
- **MAX** – This function will help to return the largest numeric value from the range of input values. Read more on the **[MAX Function](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)**.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range** – It represents the input ranges in your worksheet.

## Example:

- Now, we are going to see how to get the information based on the maximum value.
- Refer to the below image.
- Here, we will give the input values in **Column B** to **Column F**.
- Enter the formula in the formula bar section.
- Finally, we get the results in **Cell I3**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-89.png)<figcaption id="caption-attachment-20559">Example</figcaption>

## Conclusion:

In this way, you have learned the steps to look up the information based on the highest value in Excel. Let me know if you have any **doubts** regarding this article or any other Excel/VBA topic. Click here to know more about **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!** Thank You!! ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png)

### Read Also:

- **[Excel Formulas to Get Maximum Value from the Given Weekday!!](https://geekexcel.com/excel-formulas-get-maximum-value-from-given-weekday/)**
- **[Excel Formulas to Get the Maximum Value with Variable Columns!!](https://geekexcel.com/excel-formulas-maximum-value-with-variable-columns/)**