Lookup Belgian provinces in Excel based on postal code

/ Published in: Other
Save to your folder(s)

Assuming that cell E15 contains a Belgina code consisting of four numbers

Copy this code and paste it in your HTML
  1. =IF(E15<1300;"Brussel";IF(E15<1500;"Waals Brabant";IF(E15<2000;"Vlaams Brabant";IF(E15<3000;"Antwerpen";IF(E15<3500;"Vlaams Brabant";IF(E15<4000;"Limburg";IF(E15<5000;"Luik";IF(E15<6000;"Namen";IF(E15<6600;"Henegouwen";IF(E15<7000;"Luxemburg";IF(E15<8000;"Henegouwen";IF(E15<9000;"West-Vlaanderen";IF(E15<10000;"Oost-Vlaanderen";"Not found")))))))))))))

Report this snippet


RSS Icon Subscribe to comments

You need to login to post a comment.