Postcode Range

[Gwill1983]

Hi all,

I am trying to provide a postcode lookup service for our team to aid with pricing of carriage etc.

I have been supplied a list of postcodes setup in ranges which are allocated to a zone. I need to split these to show each individual postcode and what zone these are allocated to.

Before I go through manually to do this, I wanted to see if anybody knew if there was a way to allocate individual postcodes to a zone within a range.

For example,

The sheet that I have been provided looks as below

Postcode	Zone
BD 1-22, 97, 99	3
AB	9
B (excluding 1-5)	1
B1-5	101

On a seperate sheet I need to list every postcode in the country individually noting which zone these are allocated to. Is there a quick way to do this rather than manually going through the list?

Some postcode areas (such as 'B' in the list) have some that fall into one zone, and some in another.

Any help to solve this would be much appreciated.

Relatively new to power query so struggling to solve this myself





Thanks

Chris

 

[Fluff]

Duplicate to: Postcode within range

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.