Excel Formulas: INDEX and MATCH Descending Order ~ Easy Guide!!
Tags: excelformula, excelformulas
Published: 2021-01-18 04:01:39

---
title: Excel Formulas: INDEX and MATCH Descending Order ~ Easy Guide!!
published: true
date: 2021-01-11 04:42:53 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-index-and-match-descending-order/
---

Normally, we can use the [**INDEX function**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) to return the value at a given position in a range or array. This article will explain how to get the value based on **descending order by using INDEX and MATCH Functions** in Excel. Let’s get them below!! 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 the value based on descending order](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/excel_lkUxaW4K7c.png)](https://geekexcel.com/excel-formulas-index-and-match-descending-order/excel_lkuxaw4k7c/#main)<figcaption id="caption-attachment-20773">Get the value based on descending order</figcaption>
## Generic Formula:

- To retrieve the values from a table where the lookup values are sorted in descending order, 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/)(criteria,range2,-1))**

## Syntax Explanations:

- **INDEX** – In Excel, this function will 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 Excel **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** helps to locate the position of a lookup value in a row, column, or table.
- **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 data given in the worksheet.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example:

Now we are going to see how to get the value based on descending order in Excel.

- First, we will give the input values in **Column**  **B** and **Column**  **C**.

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

- Here, we need to find the **height** of the specified **age** that is given in **[Cell](https://geekexcel.com/excel-cells-options/)** F2.

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

- We will **[enter the given formula](https://geekexcel.com/how-to-enter-formula-in-excel/)** in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section or **cell F3**.

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

- This formula uses -1 for match type to allow an approximate match on values sorted in descending order.
- After applying the formula, we will get the result in **Cell F3**.

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

## Verdict:

From this tutorial, you can get to know the simple steps to find the value based on **descending order in Excel using the INDEX and MATCH functions**. Hope you like this article. Mention your **queries** in the **comment** box below. Thank you. Keep learning on **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas: Exact Match Lookup with INDEX and Match!!](https://geekexcel.com/excel-formulas-exact-match-lookup-index-match/)**
- **[Excel Formulas to Find the Exact INDEX Match in Office 365!!](https://geekexcel.com/excel-formulas-find-exact-index-match/)**