Posted By: Anonymous
I want to get the content of a cell given its row and column number. The row and column number are stored in cells (here B1,B2). I know the following solutions work, but they feel a bit hacky.
Is there no less verbose method? (like =CellValue(row,col) or whatever)?
Edit / Clarification:
I just want to use the excel worksheet formulas. No VBA. In short, I pretty much look for the equivalent of the VBA Cells() method as an excel Formula.
You don’t need the CELL() part of your formulas:
will both work. Note that both
OFFSET are volatile functions. Volatile functions can slow down calculation because they are calculated at every single recalculation.