CODEWITHSUNDEEP
excel
user1292919
user1292919

Reputation: 193

A cell contains the number of row and I want to get the value of that row on specific column

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

Upvotes: 0

Views: 34

Answers (2)

Ray
Ray

Reputation: 55

You can try this:

=INDIRECT(CONCATENATE("B",A1))

hope it works

Upvotes: 1

the Explorer
the Explorer

Reputation: 103

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

Upvotes: 1

Related Questions