=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")))))))))))))

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

Lookup Belgian provinces in Excel based on postal code

excel

Other