how to change column in formula?

[jamiguel77]

Libro1
	A	B	C	D	E	F	G	H	I
1	2	7	4	8.9	2.5		500	1	1000
Hoja1

Cell Formulas
Range	Formula
I1	I1	=A1*G1

i have in: I1 a formula: c in Cell H1 i have a value of 1

here is the goal:

if in H1 is 3: the formula in I1 would be changed automatically to: =C1*G1
if in H1 is 5: the formula in I1 would be changed automatically to: =E1*G1

how to do?

thanks

 

[Fluff]

How about

=INDEX(A1:F1,H1)*G1

 

[jamiguel77]

Yes i understand... now Index function, thanks

 

[Fluff]

You're welcome & thanks for the feedback.