How to get the value of a cell with dynamic reference

3

For example:

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

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

As an example, suppose that the value of A1 is 2 , the cell should display the value of B2 . If the value of A1 is 3 , it should display the value of B3 .

Is there a possibility?

    
asked by anonymous 16.04.2017 / 00:45

1 answer

3

I discovered by chance digging into Excel functions

=INDIRETO("B"&A1)

    
16.04.2017 / 00:58