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
Generic Formula:
- Use the below formula to group the arbitrary text in Excel.
=VLOOKUP(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.
- 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.
- Apply the above-given formula to the formula bar section and press the “Enter” key.
- Finally, it will display the result in the selected cell.
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 *and Excel Formulas *!!
Top comments (0)