Like this...

Data Range
A
B
C
D
E
F
1
ID
Age
Age Range
Age
Range
2
1
30
30 - 39
0
0 - 9
3
2
26
20 - 29
10
10 - 19
4
3
24
20 - 29
20
20 - 29
5
4
27
20 - 29
30
30 - 39
6
5
25
20 - 29
40
40 - 49
7
6
32
30 - 39
50
50 - 59
8
7
50
50 - 59
60
60 - 69
9
8
38
30 - 39
70
70 - 79
10
9
41
40 - 49
80
80 - 89
11
10
20
20 - 29
90
90 - 99
12
11
49
40 - 49
100
100 - 109
13
12
19
10 - 19
14
13
45
40 - 49
15
14
28
20 - 29
16
15
22
20 - 29
17
16
24
20 - 29
18
17
48
40 - 49
19
18
19
10 - 19
20
19
29
20 - 29
21
20
19
10 - 19
22
------
------
------
------
------
------


This formula entered in C2 and copied down:

=LOOKUP(B2,E$2:F$12)