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

20 Replies, 1874 Views

"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!"

Messages In This 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 - by - 19-04-2024, 02:07 PM



Users browsing this thread: 1 Guest(s)