How to group values with VLOOKUP

Let’s take a look.

Sometimes you better group values into discreet categories that don’t exist in your data.

Well, you could usenested IFstatements as we’ve covered in another video, and this works fine.

To do this, we need to first build the helper table.

Then we need a complete list of departments.

This is a great-use case for Excel’s built-in “remove duplicates” feature.

Just copy the values to another worksheet, and use Remove Duplicates on the Data tab of the ribbon.

Now we need to add a group for each department.

Finally, let’s use anamed rangefor the table to make theVLOOKUPformula easier to read and copy.

Next, I’ll enter the VLOOKUP formula we need to do the grouping.

When I copy this formula down, we get a group for each department.

you might also easily change the table to handle a new department.

The VLOOKUP formula will continue to work normally.