Excel function

 Trowa -
In Excel, I have a list of cities and the zip codes used in those cities. For each city I have two columns: the starting zip and the ending zip. I have a separate list of zip codes, and I want to find the city each zip belongs to.

For instance:
City Start Zip Stop zip
Wheaton, IL 60101 60399
Naperville IL 60501 60599
Chicago IL 60601 60899

So in another list I have


I want it to return "Naperville"

How do I write this in Excel?

1 reply

Hi CWebb,

For your query I would create a new sheet in which you create a long list of zip codes. For Wheaton type 60101 and 60102, select both and drag down till 60399. Then I would use VLOOKUP to find the city.

Best regards,