Find Nth Matching value with Single Criteria in Excel using INDEX!!
Tags: excelbasics, excelpreface, exceltutorials, getthenthmatchingval
Published: 2021-01-18 11:12:43

---
title: Find Nth Matching value with Single Criteria in Excel using INDEX!!
published: true
date: 2021-01-18 10:33:04 UTC
tags: ExcelBasics,ExcelPreface,ExcelTutorials,Getthenthmatchingval
canonical_url: https://geekexcel.com/find-nth-matching-with-single-criteria-in-excel/
---

As we all know, the [**INDEX**](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/) function returns the value at a given position in a range or array, and it is frequently used together with the [**MATCH**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/) function. In this tutorial, we will show how to **find the N<sup>th</sup> matching value with single criteria in Excel**?. Let’s get into this article!! 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)

## Steps to get the **N<sup>th </sup>** Match:

- Please do follow the below steps to find the N<sup>th </sup>Matching value in Excel.
- You can use the below formula based on the INDEX function.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(data,[SMALL](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(ranges=value,[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(ranges)-ROW(INDEX(ranges,1,1))+1),N))**

### Argument Explanations:

- **INDEX** – In Excel, the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** will help to return the value at a given position in a range or array.
- **SMALL** – This function will help to find the N<sup>th</sup> smallest value from the given range of data. Read more on the **[SMALL function](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)**.
- **IF** – The **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** helps to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result.
- **ROW** – It is used to return the row number for reference. Read more on the **[ROW Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)**.

### Example:

Let’s see how to find the N<sup>th</sup> matching value in a range that meets the single condition.

- 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-12.png)<figcaption id="caption-attachment-21088">Input Ranges</figcaption>

- Here, we need to find the values based on the specified position.
- Enter the given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section.

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

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, we will get the result in the selected **[cell](https://geekexcel.com/excel-cells-options/)**.

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

## Bottom-Line:

From this tutorial, you can get some clarification on how to **find the Nth matching value with single criteria in Excel**. Make use of it. If you have any **doubts** , feel free to share it with us. Thank you!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!!**

### Related Articles:

- **[Excel Formulas: INDEX and MATCH Descending Order ~ Easy Guide!!](https://geekexcel.com/excel-formulas-index-and-match-descending-order/)**
- **[Excel Formulas to Find the Position of Nth Matching Value!!](https://geekexcel.com/excel-formulas-to-find-position-of-nth-matching-value/)**