how to create a formula based on Cell Value?

[jamiguel77]

hi i have this data:

A1=5 B1=6 C1=9 D1=3
A2=2 B2=7 C2=3 D2=5
A3=2 B3=1
G1=100.21

the value in A3 give me the column number in this case 2=B and the value in B3 give me the row number.... in this case 1=first row... the combination of both values is: B1

in A4 i want do: =B1*G1

but is the values:

A3=4 B3=2 =D4

the formula changed autmatically to:

in A4 i want do: =D4*G1

Any advice?

thanks

 

[Fluff]

Shouldn't A3=4 B3=2 be D2 not D4?

 

[Peter_SSs]

Does this do what you want?

20 12 25.xlsm
	A	B	C	D	E	F	G
1	5	6	9	3			100.21
2	2	7	3	5
3	2	1
4	601.26
INDEX

Cell Formulas
Range	Formula
A4	A4	=INDEX(A1:D2,B3,A3)*G1

 

[jamiguel77]

yes D2.... error....

then reprashing:
but is the values:

A3=4 B3=2 =D2

the formula changed autmatically to:

in A4 i want do: =D2*G1

Any advice?

thanks

 

[Fluff]

Any advice?

Yes, see Peter's reply in post#3

 

[jamiguel77]

Worked, tahnks

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.