This function is used at the time when we have to categories our data into some systematic order like groups. 

So, to understand how to categories your data into groups, let’s take an example:

group by numbers

As you can see in the image above, we have taken a bunch of roll nos. and their marks scored out of 100 in some subject. 

group by numbers

Now, to categories the marks into groups, we will input the formula:

=VLOOKUP(

The following formula requires lookup value, table array, column index number, and range lookup.

group by numbers

Let’s begin with the lookup value, our lookup value is the marks in this example as this is the value that we want to organise in groups.

Previously: How to highlight blank values in excel with OR Formula?

group by numbers

Then comes the aspect of table array. 

Table array is the table according to which we will be following the things in the near future.

group by numbers

Column index number is the aspect which is to be chosen from the table array only. As we want our marks to be categorised in the group form, so our column index number will be 2, as it’s the second column in the table array which is highlighting the groups.

group by numbers

Then comes the range lookup.

In this, there will be two options True or False, this is generally an additional thing in the formula so all you have to do is press on “TRUE”.

group by numbers

So, overall the formula becomes as:

=VLOOKUP(D3,H2:I7,2,TRUE)

group by numbers

Now all we have to do is press enter, and drag the same formula down so that you don’t have to go through the formula again and again.

So, here’s your data on the screen. The marks are successfully converted into groups.

group by numbers

It’s easy, isn’t it?