Excel: get content of a cell given the row and column numbers (ADDRESS, INDIRECT, ROW, COLUMN)

A while ago, I needed to do calculations on partially absolute cell references: for some number of rows, the cells needed to be fixed to the top row of each row group. For a pure absolute cell refe…