Excel formula/function to read cell given row number and column name?

Question

Can you let me let me know how to copy the value of a cell into another cell given the row number and column name separately.

Ex: If row number=5 and column name ="A" i need to read the cell A5

I need a formula for this, so that I can copy the cell to whichever cell I want

Thanks

Srivatsava

http://srivatsava-vajapeyam.blogspot.com/

Answer 1

Still not sure what your requirement is...

$A5 will give the value of this cell, ou can write this in any other cell, and the value will get copied there.

Answer 2

Man its really simple. If you want to fix up your column and row number then keep a $ i.e. dollar sign in front of that number. Ex. if you want to copy a formula which contains A5 and you want to keep the column A constant then enter the formula as $A5 and for keeping the row constant then A$5. You can also keep both of then constant by $A$5.

Answer 3

To copy the content of the cell to another follow these steps:

First go to the cell to which u want to copy the value

Type  = ,followed by the cell address from which u have to copy the content .( in your case =A5)

That it it will copy the value.

Next time if u change the value inA5 it will be automatically update the cell u have copied to .

Answer 4

=INDIRECT("A" & "5")

or, if B1 contains the column letter, and C1 contains the row number:

=INDIRECT(B1 & C1)