Excel Formulas to Lookup Next Largest Match with MATCH Function!!
Tags: excelformula, excelformulas
Published: 2021-01-22 12:06:04

---
title: Excel Formulas to Lookup Next Largest Match with MATCH Function!!
published: true
date: 2021-01-22 12:03:15 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-lookup-next-largest-match/
---

So far, we have learned many formulas based on the [**INDEX-MATCH**](https://geekexcel.com/excel-formulas-exact-match-lookup-index-match/) function. Now, we are going to see the formula only using the [**MATCH**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) Function. Let’s come into this article. Here, is the tutorial to **lookup the next largest match in Excel by using the MATCH function**. 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)

[![Find Next largest match](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Find-Next-largest.png)](https://geekexcel.com/?attachment_id=21361#main)<figcaption id="caption-attachment-21361">Find Next largest match</figcaption>

## Generic Formula:

- Use the below formula to find the next largest value in Excel.

**=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(value,array,-1)**

## Syntax Explanations:

- **MATCH** – In Excel, the **[MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** will help to locate the position of a lookup value in a row, column, or table.
- **Value** – It is the given criteria.
- **Array** – It represents the input ranges.
- **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.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example:

Refer to the below example image. Here we will show how to get the nearest match in Excel.

- First, we will give the input values in [**Column**](https://geekexcel.com/excel-office-365-columns/) **B** and **Column**  **C**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Input-Ranges-18.png)<figcaption id="caption-attachment-21354">Input Ranges</figcaption>

- Now, we are going to look up the next largest position of the given criteria.
- Enter the above-given formula to the **[Cell](https://geekexcel.com/excel-cells-options/) F3.**

![Enter a formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Enter-a-formula-14.png)<figcaption id="caption-attachment-21355">Enter a formula</figcaption>

- Press the **ENTER** key to get the result.

![Result 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result1-1.png)<figcaption id="caption-attachment-21356">Result 1</figcaption>

- Next, we are going to find the Grade for the given criteria. To find this, we will use the below formula.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(value,array,-1))**

- Apply the above formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section and Press the **ENTER** key.

![Find the Grade](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Find-the-Grade.png)<figcaption id="caption-attachment-21357">Find the Grade</figcaption>

- Finally, we will get the result as per the given image.

![Result 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Result-2-2.png)<figcaption id="caption-attachment-21358">Result 2</figcaption>

## Wind-Up:

From this tutorial, you can get to know the simple formula used to **find the next largest match in Excel**. Hope you like it. Let me know your **doubts** from the below **comment** box. I reply to **queries** frequently. To learn more, check out **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Lookup the Next Largest Value in Excel Office 365!!](https://geekexcel.com/lookup-the-next-largest-value-in-excel-office-365/)**
- **[Excel Formulas to Find the Largest String With Criteria!!](https://geekexcel.com/excel-formulas-find-largest-string-with-criteria/)**