CODEWITHSUNDEEP
excel
Micchaleq
Micchaleq

Reputation: 433

Office reference to cell specified in another cell

Is it possible to make something like reference to column or table defined in some row?

For example: in a cell A1 I specified which column I want to choose maybe B, and in A2 I specified which row I want to choose maybe 2. So

`A1 = B, A2 = 2, B2 = 99`

Now I want to connect my A1 and A2 cell to display B2 cell. Is it possible?

Upvotes: 1

Views: 19

Answers (1)

Vityata
Vityata

Reputation: 43595

Try like this:

=INDIRECT(CONCATENATE(A1,A2))

The "Concatenate" formula would make "B2" and the "Indirect" would give you the result of the cell "B2".

Info Indirect and Info Concatenate.

Upvotes: 1

Related Questions