Forum Discussion
Bob_780
Jun 19, 2024Copper Contributor
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!
- OliverScheurichGold Contributor
- Bob_780Copper Contributor
OliverScheurich thanks!