Excel Formulas to Find Multiple Matching Values in Comma-Separated List
Tags: excelformula, excelformulas
Published: 2021-01-22 03:49:52

---
title: Excel Formulas to Find Multiple Matching Values in Comma-Separated List
published: true
date: 2021-01-21 12:04:47 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-return-multiple-matching-values-comma-separated-list/
---

Normally, we can apply the [**VLOOKUP function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/) to return the first matching values from the table cells. But, sometimes we need to extract all matching values and then separated them by a comma symbol. In this guide, we will show how to get and **return the multiple matching values in a comma-separated list in Excel**? 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)

[![Multiple Matches in Comma Separated List](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/01/Multiple-Matches-in-Comma-Seperated-List.png)](https://geekexcel.com/excel-formulas-return-multiple-matching-values-comma-separated-list/multiple-matches-in-comma-seperated-list/#main)<figcaption id="caption-attachment-21314">Multiple Matches in Comma Separated List</figcaption>
## General Formula:

- To get the multiple matches in Excel, you can use the below formula.

**=[TEXTJOIN](https://geekexcel.com/excel-textjoin-function-definition-with-examples/)(“, “,[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/),[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)(range1=criteria,range2,””))**

## Syntax Explanations:

- **TEXTJOIN** – This function will join values with a given delimiter separating each value. Read more on the **[TEXTJOIN function](https://geekexcel.com/excel-textjoin-function-definition-with-examples/)**.
- **TRUE** – In Excel, this function will help to return the value [**TRUE**](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/) if the given conditions will be TRUE or Vice Versa.
- **IF** – It helps to return one value for a TRUE result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result. Read more on the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)**.
- **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 range.
- **Criteria** – It is the specific value that wants to be found.

## Example:

To find and return the matching values in a single cell, just follow the below steps:

- Refer to the below images. First, we will enter the input values in [**Column**](https://geekexcel.com/excel-office-365-columns/) **B** and **Column**  **C**.

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

- Here we are going to group the names based on the given criteria.
- Enter the above-given formula to the **cell**  **F3** 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-20.png)<figcaption id="caption-attachment-21312">Enter the formula</figcaption>

- After applying the formula, Press **CTRL** + **SHIFT** + **ENTER**  Keys.
- Finally, we will get the result in the selected cell as per the below image.

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

## Verdict:

From this tutorial, you can get some knowledge about how to find the multiple matching values from a rang and return them into the comma-separated list in Excel. Hope you like it. Let me know your **questions** in the below **comment** sections. To learn more, check out  **[Geek Excel](https://geekexcel.com/)!!** And **[Excel Formulas](https://geekexcel.com/excel-formula/)!!**

### Related Articles:

- **[Excel Formulas to Merge the Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-merge-tables-with-vlookup/)**
- **[Combine Text from Two or More Cells into One Cell in Excel 365!!](https://geekexcel.com/combine-text-from-two-or-more-cells-into-one-cell-in-excel-365/)**