Hi All,


I need a formula to calculate values from slab Ranges.

for e.g

columnA columnB
1-10 A
11-20 B
21-30 C
31-40 D
41-50 E
51-60 F
61-70 G
71-80 H
81-90 I
91-100 J
101-110 K
111-120 L

If suppose value in cell c1 is 15, answer would be 'B' in cell D1 becuase it falls in 11-20 slab in A2.

I am using IF condition but it is not working for more than 7 times. Is there any other way to do this!

Thanks in advance!

lavi