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!

​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!   Read More

​