Excel Formulas to Match Occurrence Does not begin with Specific Value!!
Tags: excelformula, excelformulas
Published: 2021-01-18 04:06:05

---
title: Excel Formulas to Match Occurrence Does not begin with Specific Value!!
published: true
date: 2021-01-17 10:56:12 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-match-occurrence-does-not-begin-with/
---

Sometimes you need to point out the position of the value that does not match the given criteria. In this case, what would you do? Here, we come up with the simple formula used to **match the occurrence that does not begin with a specific value 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)

[![Find the occurrence that does not begin with specific value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Find-the-occurrence-that-does-not-begin-with-specific-value.png)](https://geekexcel.com/excel-formulas-match-occurrence-does-not-begin-with/find-the-occurrence-that-does-not-begin-with-specific-value/#main)<figcaption id="caption-attachment-21086">Find the occurrence that does not begin with specific value</figcaption>
## Generic Formula:

- Use the below formula to match the first value that does not begin with certain criteria given.

**=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)([FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/),data=”X”,0))**

## Syntax Explanations:

- **MATCH** – The [**MATCH function**](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)in Excel is used to locate the position of a lookup value in a row, column, or table.
- **FALSE** – In Excel, the **[FALSE function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** helps to return the logical value FALSE.
- **Data** – It is the input range.
- **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.

## Example:

Let’s consider the below example image.

- Here, we will give the input values in **Column**  **B** and **Column C**.

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

- Then, enter the given formula in 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/Enter-the-formula-11.png)<figcaption id="caption-attachment-21068">Enter the formula</figcaption>

- Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, we 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-28.png)<figcaption id="caption-attachment-21069">Result</figcaption>

## Verdict:

From this short tutorial, we have described the simple formula used to **match the occurrence that does not begin with a specific value in Excel**. Hope you like it. Please state your **query** in the below **comment** box. To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### 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/)**
- **[Formula to Count the Occurrences of a Character in a String!!](https://geekexcel.com/excel-formula-to-count-the-occurrences-of-a-character-in-a-string/)**
- **[Excel Formulas to Get the Left Lookup Value with VLOOKUP function!!](https://geekexcel.com/excel-get-left-lookup-value-with-vlookup/)**