Explanation
In this example, the goal is to group ages into buckets.
Then use a lookup function to find the right bucket or group for each age.
Also note that we are using anamed rangefor convenience only, since named ranges do not change when copied.
We don’t want this reference to change as the formula is copied down.
Because VLOOKUP is set to perform an approximate match, it has a particular behavior.
The groups in the second column can be any values you wish.
For more details on VLOOKUP, seeHow to use the VLOOKUP function.
