I would like to merge to files to create a file that matches up values based on the ranges provided in the second file. I suppose there is a reasonably simple way to do this, but I can't find it. See the example below.

Thanks
Brian

File 1
Field 1
1
2
3
4
5
6
7
8
9
10
11
12

File 2
Min | Max | Value
1 | 4 | A
5 | 8 | B
9 | 12 | C

Merged file
Field 1 | Field 2
1 | A
2 | A
3 | A
4 | A
5 | B
6 | B
7 | B
8 | B
9 | C
10 | C
11 | C
12 | C