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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
Types of cell references? 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
if the numbers in sequence 11
Cell Value as Named Range Reference 1
INDIRECT and multiple cells at once 3
look to a cell for a reference to a sheet 2
Sumif with named range of nonadjacent cells. 6

Back
Top