Can you change a cell reference using an equation?
E.g. Can I access cell A5 with '=A(2+3)' or something similar?
2006-10-15 18:41:32 · 4 answers · asked by Mox5 2 in Computers & Internet ➔ Software
Yes you can use the INDIRECT Formula
=INDIRECT("A" & (2+3), TRUE) for your example
Obviously that is not much use BUT if both the Column and the Row are the result of other formulas then this could be a useful tool.
Eg. =INDIRECT(LEFT(A1,1) & ($B$1+5), TRUE)
Note: The 'TRUE' argument specifies that you are using 'A1' rather than the 'R1C1' addressing style
2006-10-15 19:29:26 · answer #1 · answered by Norman 4 · 2⤊ 0⤋
Norman is right
You can use INDIRECT with/without ADDRESS functions to make this
ADDRESS will generate a ref in text format "Sheet1!A3" in a variable manor
While INDIRECT get the ref from a text representing a ref.
Means
=ADDRESS( 1, 2, , , )
will get the A2 in a text format
=INDIRECT( ADDRESS( 1, 2, , , ))
will get the value of A2
Read my profile, I am the XLMan
2006-10-15 23:12:42 · answer #2 · answered by Anonymous · 1⤊ 0⤋
Yes, it would be good if you expaned the question a little, that is a bit hard to understand.
2006-10-15 19:20:14 · answer #3 · answered by mysticman44 7 · 0⤊ 0⤋
No you can't so that, but perhaps give the bigger picture and someone may be able to help.
2006-10-15 18:43:48 · answer #4 · answered by teef_au 6 · 0⤊ 0⤋