Forum Discussion

Bob_780's avatar
Bob_780
Copper Contributor
Jun 19, 2024

How to specify a row number based on value in a different cell

Hi,

I want the value in cell C3 to be the number located a cell identified this way:

The column will always be A (that's easy).

The row number will be the value in cell B2 (that part I can't figure out how to do).

So, if B2 = 10, then I will want C3 to be the value in cell A10.

But the B2 values change, so I can't just say =A10.

I tried using =A(b2), but that doesn't work.

Any ideas?

Thanks!

 

Resources