Hello,
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
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.
