Suppose I have:
B1
B1
as a row variable, which will be read in conjunction with column A
into another cell (say C1
) as "=A(B1)" i.e. "=A5"How would I do this?
Using Excel INDIRECT function to lock a cell referenceEnter any value in any cell, say, number 20 in cell A1. Refer to A1 from two other cells in different ways: =A1 and =INDIRECT("A1") Insert a new row above row 1.
Getting a row number is easy—just find the cell you're interested in, click on it, and look at the highlighted row number on the side of the window. Sometimes, however, you need to use that information in a function. That's where ROW comes in. This function can be run with no arguments.
Assuming your row number is in B1
, you can use INDIRECT
:
=INDIRECT("A" & B1)
This takes a cell reference as a string (in this case, the concatenation of A
and the value of B1
- 5), and returns the value at that cell.
This should do the trick! :)
B1 =ROW(A5)
http://www.techonthenet.com/excel/formulas/row.php
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With