Excel Formulas to Find the Last Matching Value from the Text String!!
Tags: excelformula, excelformulas
Published: 2021-01-05 15:32:38

---
title: Excel Formulas to Find the Last Matching Value from the Text String!!
published: true
date: 2021-01-03 16:27:27 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-last-matching-value/
---

So far, we have learned how to get the [first matching value from the text string](https://geekexcel.com/excel-formulas-get-first-matching-value/). Suppose you need to **find the last matching value**  **from the cell** containing the text string. In this case, how could you find it? Today I introduce several tricks to solve them in Excel easily. 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)

[![Get last match](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Get-last-match.png)](https://geekexcel.com/?attachment_id=20608#main)<figcaption id="caption-attachment-20608">Get the last match</figcaption>
## Generic Formula:

- To check the cell for one of several things, and return the last match found in the list, use the below formula.

**=[LOOKUP](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/)(2,1/[SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(Things,A1),Things)**

## Syntax Explanations:

- **LOOKUP** – The [**LOOKUP Function**](https://geekexcel.com/use-lookup-function-in-microsoft-excel-365-simple-methods/) in Excel performs an approximate match lookup in a one-column or one-row range and returns the corresponding value from another one-column or one-row range.
- **SEARCH** – The [**SEARCH function**](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/) locates the character between two text strings and returns to the number of the starting position of the first text string from the first character of the second text string.
- **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.
- **Things** – It represents the input ranges that want to find the result in your worksheet.

## Example:

- First, you need to give the input values.
- Let’s consider the below example image here, we will give the input text string in **Column B**.
- Then, enter the given formula in the formula bar section.
- Finally, we will get the results in **cell C3**.

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

## Bottom-Line:

This article gives you some clarification on how to **get the last matching values in Excel**. Hope you like it. Please feel free to state your **query** or **feedback** for the above article. Click here to know more on **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- [**Excel Formulas to Sum the Values from the Last N Columns!!**](https://geekexcel.com/excel-formulas-to-sum-the-values-from-the-last-n-columns/)
- **[Excel Formulas to Get the First Matching Value from the Text String!!](https://geekexcel.com/excel-formulas-get-first-matching-value/)**