Advanced Search

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

Expand | Embed | Plain Text

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


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.