Excel Formulas Group Numbers with VLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2021-03-05 11:40:12

---
title: Excel Formulas Group Numbers with VLOOKUP Function!!
published: true
date: 2021-03-05 06:57:39 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/
---

Normally, we can use the VLOOKUP function to look up a range or table by row. Have you ever tried to group the values with the VLOOKUP function? In this tutorial, we will show the simple formula used to **group numbers with the VLOOKUP function in Excel**. Let’s get started!! 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 with VLOOKUP](https://geekexcel.com/wp-content/uploads/2021/03/Group-with-VLOOKUP.png)](https://geekexcel.com/excel-formulas-group-numbers-with-vlookup-function/group-with-vlookup/#main)<figcaption id="caption-attachment-22249">Group with VLOOKUP</figcaption>

## General Formula:

- To group the values you can use the below formula.

**=[VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(value,group\_table,column,[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/))**

## 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/).
- **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
- **Value** – It represents the criteria value for the input values.
- **Group-Table** – It represents the input table value.
- **Column** – It represents the column number.
- **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.

## Example:

Let’s consider the below example.

- First, 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-5.png)<figcaption id="caption-attachment-22250">Input Ranges</figcaption>

- Apply the above-given formula to the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)** section.

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

- Finally, it will display the result as per the below image.

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

## Wrap-Up:

Hope you like this article on **how to group the numbers with VLOOKUP Function in Excel**. Please feel free to share your **queries** in the below **comment** box. Thank you so much for visiting **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Related Articles:

- **[Excel Formulas: IF Function with Other Calculations!!](https://geekexcel.com/excel-formulas-if-function-with-other-calculations/)**
- **[Formulas for Counting Cells that Contain any Text in Excel Office!!](https://geekexcel.com/formulas-for-counting-cells-that-contain-any-text-in-excel-office/)**
- **[Excel Formulas to Test Multiple Cells and Return Non-Blank Value!!](https://geekexcel.com/excel-formulas-multiple-cells-and-return-non-blank-value/)**