Looking up a value within a range

Hi All,    Good day, was wondering if you can help me out and try to figure out the best possible solution with what i am trying to do.    Concern: Im trying to group certain folks into a cluster...