Excel Formulas to Get the Nth Matching Value Using VLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2021-01-18 03:56:28

---
title: Excel Formulas to Get the Nth Matching Value Using VLOOKUP Function!!
published: true
date: 2021-01-06 17:12:56 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-nth-value-vlookup/
---

So far we have learned how to get the [N<sup>th</sup> matching value with the INDEX function](https://geekexcel.com/excel-formulas-nth-matching-value-with-index/). Here we will show the formula to **get the N<sup>th</sup> occurrence of a value by using the VLOOKUP function in Excel**. Let’s see 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)

[![Formulas to get the Nth value with VLOOKUP](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Formulas-to-get-the-Nth-value-with-VLOOKUP.png)](https://geekexcel.com/excel-formula-nth-value-vlookup/formulas-to-get-the-nth-value-with-vlookup/#main)<figcaption id="caption-attachment-20737">Formulas to get the Nth value with VLOOKUP</figcaption>

## General Formula:

- The below formula will help you to get the N<sup>th</sup> Matching value.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(id\_formula, data,column,0)**

**ID Formula =A2&”-“&[COUNTIF](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)([$A$2](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/):A2,A2)**

## Syntax Explanations:

- **VLOOKUP** – In Excel, this function will help to lookup data in a range or table by row. Read more on the **[VLOOKUP Function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)**.
- **COUNTIF** – This function will help to count the number of cells that meet a single condition or criteria. Read more of the **[COUNTIF function](https://geekexcel.com/formulas-to-count-with-countif-function-in-excel-office-365/)**.
- Absolute Reference – The **[absolute reference](https://geekexcel.com/use-absolute-reference-in-excel-office-365-with-examples/)** is an actual fixed location in a worksheet.
- **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.
- **Data** – It represents the input ranges in your worksheet.
- **Column** – It represents the column Number of your input data.

## Example:

Please do as follows to find the N<sup>th</sup> occurrence of a value in Excel.

- First, you need to give the input values.

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

- The N<sup>th</sup> occurrence of a value by using the VLOOKUP function depends on a helper column, which is added at the first **[column](https://geekexcel.com/excel-office-365-columns/)** of the source data table.
- The helper column contains the given ID formula.

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

- In this example, we need to find the Amount of specified Order ID.

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

- [**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 any **[cell](https://geekexcel.com/excel-cells-options/)** in which you want to show your result.

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

- Finally, you can get the result as per your data.

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

## Wrap-Up:

So yeah guys, this is how we can **get the N<sup>th</sup> occurrence of the given criteria in Excel by using the VLOOKUP function**. Hope you like it. If you have any **queries,** don’t forget to let me know. Click here to know more on **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!** Thank you!! ![🙏](https://s.w.org/images/core/emoji/13.0.1/72x72/1f64f.png)

### Read Ahead:

- **[Formula to Find Position of Nth Occurrence of a Character in Text String!!](https://geekexcel.com/formula-to-find-position-of-nth-occurrence-of-a-character-in-text-string/)**
- **[Excel Formulas to Get the Name of Nth Largest Value!!](https://geekexcel.com/excel-formulas-get-name-nth-largest-value/)**