Get content of a cell given the row and column numbers

You don’t need the CELL() part of your formulas:



=OFFSET($A$1, B1-1,B2-1)

will both work. Note that both INDIRECT and OFFSET are volatile functions. Volatile functions can slow down calculation because they are calculated at every single recalculation.

Leave a Comment