Help with formula

Question

I am trying to return a number based on where that cell falls in between a range of numbers.&nbsp;
Example is if the number in cell A1 = 4200, then I&nbsp;need&nbsp;B2 to return the data&nbsp;from column C. 4200 would return .2 (C7).
If A1 = 7000, then B2 would return .15 (C11).
&nbsp;
I appreciate any help I can get!
&nbsp;

A
B
C

&nbsp;4200
&nbsp;
&nbsp;

1
2000
0.3

2000
2500
0.26

2500
3000
0.25

3000
3500
0.24

3500
4000
0.22

4000
4500
0.2

4500
5000
0.18

5000
5500
0.17

5500
6500
0.16

6500
7500
0.15

7500
8500
0.145

8500
9500
0.14

9500
10500
0.13

10500
11500
0.125

11500
12500
0.12

12500
13500
0.115

13500
15000
0.11

15000
18000
0.105

18000
21000
0.1

21000
24000
0.095

24000
27000
0.9

27000
30000
0.087

30000
35000
0.084

35000
40000
0.083

40000
45000
0.08

45000
50000
0.077

50000
60000
0.075

60000
70000
0.074

70000
80000
0.073

80000
90000
0.072

90000
100000
0.071

100000
&nbsp;
0.07

gourab dasgupta · Accepted Answer

Please go through my attachment and reply if you get the output you want. Thanks.

Forum Discussion

Help with formula

2 Replies

Resources

A	B	C
4200
1	2000	0.3
2000	2500	0.26
2500	3000	0.25
3000	3500	0.24
3500	4000	0.22
4000	4500	0.2
4500	5000	0.18
5000	5500	0.17
5500	6500	0.16
6500	7500	0.15
7500	8500	0.145
8500	9500	0.14
9500	10500	0.13
10500	11500	0.125
11500	12500	0.12
12500	13500	0.115
13500	15000	0.11
15000	18000	0.105
18000	21000	0.1
21000	24000	0.095
24000	27000	0.9
27000	30000	0.087
30000	35000	0.084
35000	40000	0.083
40000	45000	0.08
45000	50000	0.077
50000	60000	0.075
60000	70000	0.074
70000	80000	0.073
80000	90000	0.072
90000	100000	0.071
100000		0.07