Excel Formulas to Find the Partial Match Against the Number!!
Tags: excelformula, excelformulas
Published: 2021-01-26 08:44:16

---
title: Excel Formulas to Find the Partial Match Against the Number!!
published: true
date: 2021-01-25 12:16:31 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-find-partial-match-against-the-number/
---

Whenever you want to perform a partial matching in Excel, the most obvious solution is to use wildcards. Three types of Excel wildcard characters are **Asterisk (\*), Question Mark (?),** and **Tilda (~).** Here is the tutorial to **find the partial match against a number with a wildcard 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)

[![Partial match against the number](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Partial-match-against-the-number.png)](https://geekexcel.com/excel-formulas-find-partial-match-against-the-number/partial-match-against-the-number/#main)<figcaption id="caption-attachment-21401">The partial match against the number</figcaption>
## Generic Formula:

- Use the below array formula to get the position of the partial match against the numbers in Excel.

**=[MATCH](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)(“\*”&number&”\*”,[TEXT](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)(range,”0″),0)**

## Syntax Explanations:

- **MATCH** – In Excel, the **[MATCH function](https://geekexcel.com/how-to-use-match-function-in-microsoft-excel-365/)** will help to locate the position of a lookup value in a row, column, or table.
- **TEXT** – The **[TEXT function](https://geekexcel.com/how-to-use-text-function-in-microsoft-excel-365/)** helps to convert a number to text in the given format.
- **Asterisk (\*)** – This wildcard will represent any number of characters.
- **Number** – It is the criteria that want to be found.
- **Range** – It represents the input data from your 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.

## Practical Example:

Let’s see how to find the position of the partial match against a number.

- First, we will give the input data in **[Column](https://geekexcel.com/use-column-function-in-microsoft-excel-365-simple-methods/) B**.

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

- Then, apply the above-given formula to the **cell E3** or [**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-22.png)<figcaption id="caption-attachment-21398">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- It will display the result as shown below.

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

## Closure:

From this short tutorial, we have guided you to learn the simple formula used to **find the partial match against the number in Excel by using the wildcard**. Let me know your **feedback** in the below **comment** section. To learn more, check out **[Geek Excel](https://geekexcel.com/)** and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Extract all Partial Matches ~ Easy Method!!](https://geekexcel.com/excel-formulas-extract-all-partial-matches/)**
- **[Excel Formulas to Find the First Matching Values in Range with Wildcard!!](https://geekexcel.com/excel-formulas-find-first-matching-values-with-wildcard/)**