Excel Formulas to Group the Arbitrary Text Values ~ Simple Tutorial!!
Tags: excelformula, excelformulas
Published: 2021-03-05 12:01:53

---
title: Excel Formulas to Group the Arbitrary Text Values ~ Simple Tutorial!!
published: true
date: 2021-03-05 08:04:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-group-the-arbitrary-text-values/
---

Sometimes, you may need to group or classify the data based on arbitrary text values. In this situation, how can you calculate them quickly? Here, we will discuss the simple formulas used to **group the arbitrary text values 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)

[![Group Arbitrary text value](https://geekexcel.com/wp-content/uploads/2021/03/Group-Arbitrary-text-value.png)](https://geekexcel.com/excel-formulas-to-group-the-arbitrary-text-values/group-arbitrary-text-value/#main)<figcaption id="caption-attachment-22212">Group Arbitrary text value</figcaption>

## Generic Formula:

- Use the below formula to group the arbitrary text in Excel.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(value,table,column,0)**

## Syntax Explanations:

- **VLOOKUP** – This function is used to look up data in a range or table by row. Read more on the [**VLOOKUP Function**](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/).
- **Value** – It represents the criteria value for the input values.
- **Point-Table** – It represents the input table value.
- **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 consider the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we are going to group the values based on the given table in **Column F** and **Column G**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/03/Input-Ranges-3.png)<figcaption id="caption-attachment-22213">Input Ranges</figcaption>

- Apply the above-given formula to the **formula bar** section and press the **“Enter”** key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/03/Enter-the-formula-3.png)<figcaption id="caption-attachment-22215">Enter the formula</figcaption>

- Finally, it will display the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/03/Result-4.png)<figcaption id="caption-attachment-22214">Result</figcaption>

## Verdict:

From this tutorial, we have described the simple formula used to **group the arbitrary text values in Excel**. Hope you like this article. Let me know your **queries** in the below **comment** section. Click here to know more details **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas: IF Function with Wildcard Characters!!](https://geekexcel.com/excel-formulas-if-function-with-wildcard-characters/)**
- **[How to use VLOOKUP to Create a Search Box? ~ Complete Guide](https://geekexcel.com/how-to-create-search-box-vlookup-function/)**