You can use the following syntax in Excel with the **MAX** and **VLOOKUP** functions to find the max value in a range and return a corresponding value:

=VLOOKUP(MAX(A2:A11), A2:B11, 2, FALSE)

This particular formula uses **MAX** to find the max value in the range **A2:A11** and then uses **VLOOKUP** to look up the value in the range **B2:B11** that corresponds to this max value.

The following example shows how to use this formula in practice.

**Example: How to Use VLOOKUP with MAX in Excel**

Suppose we have the following dataset that contains information about points scored by various basketball players:

Suppose we would like to look up the max value in the points column and return the corresponding team name.

We can type the following formula into cell **D2 **to do so:

=VLOOKUP(MAX(A2:A11), A2:B11, 2, FALSE)

The following screenshot shows how to use this formula in practice:

This formula uses the **MAX** function to find the max value of 40 in the points column.

Then, the formula uses the **VLOOKUP** function to return the team name **Warriors**, which is the team that corresponds to the max value in the points column.

**Bonus: Find the Max Value Associated with a Lookup Value**

If you instead wanted to find the max value associated with a specific lookup value, you could use the **MAXIFS** function instead.

For example, you could use the following formula to find the max value associated with the “Warriors” team:

=MAXIFS(B2:B9, A2:A9, "Warriors")

The following screenshot shows how to use this formula in practice:

The formula returns a value of **32**, which is the max value associated with the “Warriors” in this dataset.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Perform a VLOOKUP with Two Lookup Values

Excel: How to Use VLOOKUP to Return Multiple Columns

Excel: How to Use VLOOKUP to Return All Matches