"Hey everyone, quick question—how do I use google sheets get value at address in a formula?
I’m trying to pull a value from a specific cell (like "A1" or "B3") but not sure the best way to do it.
I’ve seen INDIRECT() mentioned, but is that the simplest method? Or is there a cleaner way?
Also, if the address is stored in another cell (like "D1" has "A1" written in it), how do I make google sheets get value at address dynamically?
Thanks in advance! And sorry if this is a noob question—still getting the hang of Sheets lol.
P.S. If there’s a better function than INDIRECT(), lmk!"
I’m trying to pull a value from a specific cell (like "A1" or "B3") but not sure the best way to do it.
I’ve seen INDIRECT() mentioned, but is that the simplest method? Or is there a cleaner way?
Also, if the address is stored in another cell (like "D1" has "A1" written in it), how do I make google sheets get value at address dynamically?
Thanks in advance! And sorry if this is a noob question—still getting the hang of Sheets lol.
P.S. If there’s a better function than INDIRECT(), lmk!"
