Excel Formulas to Get the First Matching Value from the Text String!!
Tags: excelformula, excelformulas
Published: 2021-01-12 03:48:10

---
title: Excel Formulas to Get the First Matching Value from the Text String!!
published: true
date: 2020-12-30 06:09:24 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-get-first-matching-value/
---

Suppose you have a text string in your worksheet, and you need to find the specific value from the cell. In this case, how could you find it? Here, we will show the simple formula used to **get the first matching value from the text string in Excel**. 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)

![Find the first matching value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/12/find-the-first-matching-value.png)<figcaption id="caption-attachment-20483">Find the first matching value</figcaption>

## General Formula:

- To get the first matching value from the text string, you can use the **INDEX function** along with the **MATCH function**.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(Range,[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),[ISNUMBER](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)([SEARCH](https://geekexcel.com/use-search-function-in-microsoft-excel-2013-simple-methods/)(Range,A1)),0))**

## Syntax Explanations:

- **INDEX** – The **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)** returns the value at a given position in a range or array.
- **MATCH** – In Excel, this function will help to locate the position of a lookup value in a row, column, or table. Read more on the **[MATCH Function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)**.
- **TRUE** – This function will return the value **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** if the given conditions will be TRUE.
- **ISNUMBER** – The **[ISNUMBER function](https://geekexcel.com/how-to-use-isnumber-function-in-microsoft-excel-365/)** returns TRUE when a cell contains a number, and FALSE if there will not be a number.
- **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.
- **Range** – It represents the input ranges in your worksheet.

## Example:

- Refer to the below image.
- First, we will give the input text string in **Column B**.
- Then, enter the given formula in the formula bar section.
- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, we will get the result in **Cell C3**.

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

## Verdict:

In this tutorial, we have described the formulas used to **get the first matching value in Excel**. Hope you like it. If you have any issue regarding this article or any unresolved query, please comment in the comment box below. We will assist you. Click here to know more on **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas to Find the Exact INDEX Match in Office 365!!](https://geekexcel.com/excel-formulas-find-exact-index-match/)**
- **[Excel Formulas to Find the First Matching Values in Range with Wildcard!!](https://geekexcel.com/excel-formulas-find-first-matching-values-with-wildcard/)**