Formula is required

[decent_boy]

I have below data and I need a formula in e3 , when I insert value in e as I am showing calculation in column C but it is not be any lookup formula it jus a calculation which can see from column b to column c.

Book2
	A	B	C	D	E	F
1	Number		Total Value		Random Num
2	1	1	1		20
3	2	1.02	2.02		23.3	Need Formula in E3
4	3	1.04	3.06
5	4	1.06	4.12
6	5	1.08	5.2
7	6	1.1	6.3
8	7	1.12	7.42
9	8	1.14	8.56
10	9	1.16	9.72
11	10	1.18	10.9
12	11	1.2	12.1
13	12	1.22	13.32
14	13	1.24	14.56
15	14	1.26	15.82
16	15	1.28	17.1
17	16	1.3	18.4
18	17	1.32	19.72
19	18	1.34	21.06
20	19	1.36	22.42
21	20	1.38	23.8
Fresh Data Sheet

Cell Formulas
Range	Formula
B2	B2	=A2
C2	C2	=SUM(B2)
B3:B21	B3	=(A2*0.02)+$B$2
C3:C21	C3	=SUM($B$2:$B3)

 

[DanteAmor]

Try:

=VLOOKUP(E2,A:C,3,0)

 

[decent_boy]

Try:

=VLOOKUP(E2,A:C,3,0)

Thanks for your reply but this is not what i asked I mean when I type in random number it makes a single calculation of both formulas of col b and col c

 

[decent_boy]

Furthermore, you can see formula in column b where value is multiplying by 0.02 and in column c formula of sum

 

[DanteAmor]

Sorry, I didn't check well, can you explain how you get this result in cell E3: 23.3

 

[decent_boy]

please see row 23 of column b and col c

Book2
	A	B	C
21	20	1.38	23.8
Fresh Data Sheet

Cell Formulas
Range	Formula
B21	B21	=(A20*0.02)+$B$2
C21	C21	=SUM($B$2:$B21)

 

[decent_boy]

DanteAmor​

I just need a single formula which calculation you can see in column b and column c.

 

[Fluff]

Is this what you want

=SUMPRODUCT(ROW(INDIRECT("1:"&E2-1))*0.02+1)+1

 

[decent_boy]

Yes, this what I want
Thank you so much for your support

 

[Fluff]

Glad w could help & thanks for the feedback.