Forum Discussion

Bob_780's avatar
Bob_780
Copper Contributor
Jun 19, 2024
Solved

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 figur...
  • OliverScheurich's avatar
    Jun 19, 2024

    Bob_780 

    =INDIRECT(ADDRESS(B2,1))

    This works if i correctly understand what you are looking for.

Resources