How do I use google sheets get value at address in a formula? or What's the best way to get a value a

INDIRECT is the go-to, but it’s volatile (recalculates a lot). If you’re on a big sheet, be careful.

For a non-volatile option, you could use INDEX + ROW/COLUMN, but it’s clunkier.

Example:
`=INDEX(A:A, 1)` for A1.

Not as flexible but faster in big sheets.