Hi, basically what I need is based on where the Key falls in the interval for each quarter, a column indicating the proper group it belongs should be created from have1. Left join won't work since I don't really have a unique key, this is simply a lookup based on a range. Any help is appreciated! Example: have1: Quarter Key 1 31.39715 1 53.59118 1 84.20986 1 81.27638 2 58.62042 2 12.07567 2 91.42742 3 69.06109 4 53.8079 4 33.30056 have 2: Quarter Group Cutoff 1 A 20 1 B 50 1 C 90 1 D 100 2 A 10 2 B 20 2 C 30 2 D 100 3 A 60 3 B 70 3 C 80 3 D 100 4 A 10 4 B 60 4 C 99 4 D 100 want: Quarter Key Group 1 31.39715 B 1 53.59118 C 1 84.20986 C 1 81.27638 C 2 58.62042 D 2 12.07567 B 2 91.42742 D 3 69.06109 A 4 53.8079 A 4 33.30056 A
... View more