Excel Formulas to Get the Position on the Last Matching Value!!
Tags: excelformula, excelformulas
Published: 2021-01-12 03:51:56

---
title: Excel Formulas to Get the Position on the Last Matching Value!!
published: true
date: 2021-01-03 16:17:32 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-position-of-last-matching-value/
---

Normally, when using the [**Vlookup function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) to search for a value, it will return the corresponding result for the first matching. If you have a list of items that are repeated many times, and you need to know the **position of the last matching value** with your specified data. How could you solve this problem? This article will introduce several tricks to solve them in Excel easily. Let’s get started!!

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 find the position of the last occurrence](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Formulas-to-find-the-position-of-the-last-occurrence.png)](https://geekexcel.com/excel-formulas-get-position-of-last-matching-value/formulas-to-find-the-position-of-the-last-occurrence/#main)<figcaption id="caption-attachment-20564">Formulas to find the position of the last occurrence</figcaption>

## Jump To:

- [**General Formula**](#1)
- [**Syntax Explanations**](#2)
- [**Practical Example**](#3)
- [**Wind-Up**](#4)

## General Formula:

- Use the below formula to find the position of the last occurrence.

**=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(criteria,[ROW](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)(range)-[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(ROW(range))+1))**

## Syntax Explanations:

- **MAX** – This function will help to return the largest numeric value from the range of input values. Read more on the **[MAX Function](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)**.
- **IF** – The Excel** [IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** return one value for a TRUE result, and another for a FALSE result.
- **ROW** – In Excel, the **[ROW Function](https://geekexcel.com/row-function-in-microsoft-excel-365-how-to-use/)** will return the row number for reference.
- **MIN** – This function helps to return the smallest numeric value from the range of input values. Read more on the **[MIN Function](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)**.
- **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 ranges in your worksheet.
- **Plus operator (+)** – This symbol is used to add the values.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example:

- Let’s see the below example image to get the position of the last matching value.
- Here, we will give the input range in **Column B**.
-  Then, enter the given formula in the formula bar section.
- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- It will display the result in **Cell E4**.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/Example-90.png)<figcaption id="caption-attachment-20563">Example</figcaption>

## Wind-Up:

![🤞](https://s.w.org/images/core/emoji/13.0.1/72x72/1f91e.png) Hope you understood the formula to get the position of the last occurrence in Excel. If you have any **doubts** regarding this topic or any other Excel VBA related topic, ask in the **comments** section below. I reply to queries frequently. To learn more, check out **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Find the Average of Last N Values from a Column!!](https://geekexcel.com/excel-formulas-to-find-the-average-of-last-n-values-from-a-column/)**
- **[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/)**