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

For google sheets get value at address, INDIRECT is the standard. But it’s not the *only* way.

You could also use:
`=IMPORTRANGE("url", "A1")` if pulling from another sheet.

But yeah, for same-sheet stuff, INDIRECT wins.