Lookup within range?

[CBecke]

Hi. Newbie here.

I have one data set with values and another data set with minimum/maximum ranges. I'd like to do a join to append some data if the value falls within the range.

Think of this as similar to one table of student test scores and another table that contains letter grades assigned to score ranges:

Score

54

92

85

67

72

Letter min max

A 90 100

B 80 89

C 70 79

D 60 69

F 0 59

How do you do a conditional join to result in:

Score Letter

54 F

92 A

85 B

67 D

72 C

Thanks for your guidance.

(Note that an Append Fields cartesian join will result in 1.4 million records! Not sure if that's something my PC can handle)

[CBecke · Accepted solution]

Actually, 1.4 million records wasn't a problem at all. I used an Append Fields with the necessary columns from both sets of data, then a filter to choose the values that were "in range".

Worked great!