I can explicitly reference cell G42
or range A42:G42
.
But what if I need something dynamic?
For example: I want to write an expression in cell G200
, which would calculate the average of cells A42:G42
, without explicitly writing A42:G42
, but by taking the value of cell G201
, which is 42, finding "G
" by seeing in which column the current cell is and finding "A
" by going seven columns back from column G
.
Is this possible?