Use LOOKUP formula to group values


Normally I would use a reference table and VLOOKUP, but this seems to work quite well and fast as well.
A light solution to a simple question!

LOOKUP