## Explanation

This formula uses the value in cell D5 for a lookup value, the named range "age_table" (G5:H8) for the lookup table, 2 to indicate "2nd column", and TRUE as the last argument indicate approximate match.

*Note: the last argument is optional, and defaults to TRUE, but I like to explicitly set the matching mode.*

VLOOKUP simply looks up the age and returns the group name from the 2nd column in the table. This column can contain any values that you wish.

### Pivot tables

Pivot tables can automatically group numbers, but the VLOOKUP approach allows you to perform completely custom grouping.

## Related formulas

### VLOOKUP calculate grades

### Get employee information with VLOOKUP

### Map inputs to arbitrary values

### VLOOKUP two-way lookup

### Merge tables with VLOOKUP

### VLOOKUP without #N/A error

## Related functions

### VLOOKUP Function

VLOOKUP is an Excel function to look up data in a table organized *vertically*. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the *first* column of the table...