I seem to have done it backwards to the solution. Rather than expanding the reference table to include all post codes, I used a formula to add the ranges to the source data. The solutions method works way better if there was more data in the reference table.
This was pretty enjoyable for a 2am challenge, I think I will work my way through the rest of these challenges. 😁