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 your friend here!

One thing to watch: if the referenced cell changes (like D1’s value updates), INDIRECT will auto-update.

If you need a static snapshot, copy-paste values or use a script.

Also, Ben Collins’ site has great INDIRECT examples—check it out!