Excel Formulas Used to Categorize the Text Based on Keywords!!
Tags: excelformula, excelformulas
Published: 2021-03-06 04:33:51

---
title: Excel Formulas Used to Categorize the Text Based on Keywords!!
published: true
date: 2021-03-05 11:47:22 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-used-to-categorize-the-text-based-on-keywords/
---

Assume that, you have a list of text strings in one column, and you need to categorize them based on certain keywords. How could you finish this complicated job quickly and easily in Excel? Not to worry. In this article, I introduce some formulas which can quickly **categorize the text based on given keywords 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)

[![Categorize items with keywords](https://geekexcel.com/wp-content/uploads/2021/03/Categorize-items-with-keywords.png)](https://geekexcel.com/excel-formulas-used-to-categorize-the-text-based-on-keywords/categorize-items-with-keywords/#main)<figcaption id="caption-attachment-22281">Categorize items with keywords</figcaption>
## Generic Formula:

- The below formula will help you to categorize the text string.

**=[INDEX](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(categories,[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/)(keywords,text)),0))**

## Syntax Explanations:

- **INDEX** – This function will help to return the value at a given position in a range or array. Read more on the **[INDEX function](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)**.
- **MATCH** – It helps 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** – The **[TRUE function](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** will help to return the value TRUE if the given conditions will be TRUE or Vice Versa.
- **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 Excel** [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.
- **Categories** – It represents the criteria value for the input values.
- **Text** – 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.

- First, we will enter the input values in **Column B** , and now we are going to categorize the text string based on the keywords which are given in **Column E** and **Column F**.

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

- So, apply the given formula to the formula bar section.
- After that, Press **CTRL** + **SHIFT** + **ENTER**  Keys.

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

- Finally, we will get the result in the selected cell.

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

## Wrap-Up:

From this tutorial, you can get some clarification on **how to categorize the text string based on keywords in Excel**. Hope you like it. Let me know if you have any **doubts** regarding this article or any other article on this site. To learn more, check out **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Also:

- **[Excel Formulas to Group the Arbitrary Text Values ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-group-the-arbitrary-text-values/)**
- **[Excel Formulas Group Numbers with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/)**