Lookup the Next Largest Value in Excel Office 365!!
Tags: excelpreface, lookupthenextlargest, excelbasics, exceltutorials
Published: 2021-01-19 11:37:48

---
title: Lookup the Next Largest Value in Excel Office 365!!
published: true
date: 2021-01-19 10:36:48 UTC
tags: ExcelPreface,LookuptheNextLargest,ExcelBasics,ExcelTutorials
canonical_url: https://geekexcel.com/lookup-the-next-largest-value-in-excel-office-365/
---

In this post, we will show you the steps to **[Lookup](https://geekexcel.com/lookup-and-reference-functions-in-microsoft-excel-365/) the Next Largest Value in Excel Office 365**. Here, we are going to get the next largest value in a range using Excel functions such as [INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) and [MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/). Follow the steps given in this post, so you can quickly complete the task. Let’s see them below.
## Syntax and its Description:

- You can use the [**INDEX** function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) with the [**MATCH** Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) to look up the next largest value of the given number in Excel.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(B2:B5,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),A2:A5>300,0))**

- **INDEX function –** This function returns the value at a given position in a range or array. INDEX is frequently used together with the MATCH function.
- **MATCH function –** It is used to locate the position of a lookup value in a row, column, or table.
- **TRUE function –** It returns the value TRUE if the given conditions will be TRUE or Vice Versa.

## Steps to Lookup the Next Largest Value:

The following steps will help you to understand how it works.

- Assuming that we have a list of products and their price amount.
- We are going to **find** the **product** whose price is **more than 300** from the input range.
- In the below screenshot, you can see the example data.

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

- Then you need to enter the above-given formula in any cell. Here, we entered the formula in **Cell E3.**

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

- After entering the formula, you need to press  **CTRL** + **SHIFT** + **Enter** keys to get the result.
- Refer to the below screenshot.

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

## Closure:

In this post, we have described the steps to **Lookup the Next Largest Value in Excel Office 365**. Give your **suggestions** or **feedback** in the below comment box. Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [Excel Formulas to Lookup Multiple Criteria with INDEX and MATCH!!](https://geekexcel.com/excel-lookup-multiple-criteria-with-index-and-match/)
- [Use Find & Replace Tool to Replace Text in Excel Office 365](https://geekexcel.com/use-find-replace-tool-to-replace-text-in-excel-office-365/)