First, sorry that I can't provide you with table.. I have no idea how to use this .
I have A column containing the number of rows. For example, A1 is 900. Then I want to put the value of B900 on column C
Is there any function for this one?
what I have tried is add "B" to A1 to make B900 and use =value(A1), but it gives me #value!
Can you please help me
Thanks
You can use 'INDIRECT' built-in function of Excel:
Example:
Suppose you have A column containing the number of rows. For example, A1 is 900. Then you want to put the value of B900 on column C
in Cell C2 you can type the formula as
=INDIRECT("B"&A1)
And you will definitely get value of B900 in the cell C2
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments