Deriving zip code from adress

[Eitan_tom]

Hey excel genius,

I have a simple question, I have a list of locations without zip code.

How can I derive the zip code form the address.

I have street name, street number and city.

It is apply to the Netherlands.


Is the Geography option in excel can help me with it?

Thankssssss

 

[queuesmef]

if there is a downloadable file that has the zip codes for the Cities OR Streets you could perform a Vlookup on that file to put in the correct zip code.