How to take the value of a cell with dynamic reference

Asked

Viewed 10,539 times

3

For example:

In the cell A1 will contain a number, which will be the line to be considered.

In the cell A2 need a function to display the value of a cell as typed in A1, something like =B"A1".

As an example, suppose the value of A1 be it 2, the cell shall show the value of B2. If the value of A1 for 3, should show the value of B3.

Is there such a possibility?

excel
  • 1

    @dot. Py do not see the need for the cited tag, since it doesn’t even exist here and that the excel tag already covers that it is a formula problem, because if it is vba, it will have this tag too.

  • @diegofm good, ok then! thank you for your attention.

1 answer

3


I discovered by chance digging into the functions of Excel

=INDIRETO("B"&A1)

Browser other questions tagged excel

You are not signed in. Login or sign up in order to post.