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 answer, but here’s a niche case:

If you’re pulling from a *named range*, you can just use the name directly (no INDIRECT needed).

Example:
Define "MyRange" as A1, then use `=MyRange`.

Cleaner if you’re reusing the same cell a lot.