jamiguel77
Active Member
- Joined
- Feb 14, 2006
- Messages
- 378
- Office Version
- 2016
- 2010
- 2007
- Platform
- Windows
- Web
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
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