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() works, but if you’re just pulling static cells (not dynamic refs), you can just reference them directly like `=A1`.

For dynamic stuff tho, yeah, INDIRECT is the only way I know to google sheets get value at address stored as text.

Check out Sheetgo’s blog—they have a solid guide on INDIRECT uses.