LOOKUP’s default behavior makes it useful for solving certain problems in Excel.
Group numbers at uneven intervals
To group numbers into intervals of unequal size, you can use the LOOKUP function. In the example shown, the LOOKUP function is used to group people by age into at intervals of unequal size. The formula in D5 is: =LOOKUP(C5,age,group) Where "age" is the named range F5:F8 and "group" is the named range G5:G8.
