Excel function Closed

Question

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

So in another list I have

60532

I want it to return "Naperville"

How do I write this in Excel?

Trowa · Answer

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,
Trowa

Excel function

1 response

Similar discussions

Subscribe To Our Newsletter!