Final solution is pretty small - this won't give anything away - detail of each piece in the spoiler below
I'd love to figure out a more streamlined approach. Here's my go at it, not very different from anyone else.
Sometimes I do actually miss the INDIRECT function.....
ABSOLUTELY - and Indirect function would have been super valuable in a dozen places at work too (not just weekly challenges).
I think there's an idea out there for Indirect @EstherB47 - if not, log it and I'll definitely vote for it!
Hi @SeanAdams . I just checked the ideas, and indeed there is one already there. And wow would it help!!!
Like. Rinse. Repeat.