We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
Key challenge is to address the multiple match which couldn't be handled by a single Find/Replace tool (which always returns the first match like Excel VLookUp). Got some hints of using Cartesian Join and then match + filter to retrieve all correct matches.
This one made me think a bit. Ultimately I went for a bit of a tool array!