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...