The magic in Excel’s ‘indirect’ function

Angel Demirev
Aug 6, 2018 · 2 min read
I’ve shared a copy of this spreadsheet if you’d like to look deeper. Note that if the tabs contained spaces, we’d need to concatenate-in single quotes, but I’ve left these out for simplicity.

When would I use this function?

Angel Demirev

Written by

Living in San Francisco

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade