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

+- Proxy Community (https://proxycommunity.com/forum)
+-- Forum: Proxy Tools (https://proxycommunity.com/forum/forum-proxy-tools)
+--- Forum: Software (https://proxycommunity.com/forum/forum-software)
+--- Thread: How do I use google sheets get value at address in a formula? or What's the best way to get a value a (/thread-how-do-i-use-google-sheets-get-value-at-address-in-a-formula-or-what-s-the-best-way-to-get-a-value-a)

Pages: 1 2 3


“” - maskedTrekX99 - 04-04-2025

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.