using the value in a cell as part of another cell reference

  • Thread starter Thread starter Earl Kiosterud
  • Start date Start date
E

Earl Kiosterud

Stephen,

=INDIRECT("A1") refers to A1, and returns what's in A1
=INDIRECT(A1) refers to whatever A1 points to
(if A1 contains "A2" then you'd get what's in A2)
Your question:
=INDIRECT("A" & K10)
(if K10 contains 5, then you'd get what's in A5)

You can also use
=OFFSET(A1,K10-1,0,1,1)
This one isn't confounded by fractional numbers (if K10 contains 5.5, it
still refers to A5). The INDIRECT formula would fail.

These will all fail if K10 doesn't contain a number between 1 and 65,536 (a
valid row number)
 
I want to use the value in one cell as part of the reference for another.
eg. A(K10). is there an easy or any way. Pretty new to this, if I'm asking
the obvious.
As I can't find a function or other method.
Steve
 
Back
Top