I can explicitly reference cell
G42 or range
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
Is this possible?