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

If you’re just starting with google sheets get value at address, stick with INDIRECT. It’s the simplest for dynamic refs.

But if you’re feeling adventurous, QUERY can sometimes pull cell values too, though it’s overkill for single cells.

Example:
`=QUERY(A1, "select A")`

Weird, but works lol.