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

Hey! INDIRECT is the answer, but here’s a pro tip:

If you’re building the address from parts (like row + column), use:
`=INDIRECT("A" & 1)`

Super handy for dynamic ranges.

Also, if you’re doing this a lot, maybe try Apps Script? Overkill for small tasks but powerful.