Previous Topic Next Topic

Excel function

Closed
CWebb - Nov 30, 2009 at 12:02 PM
 Trowa - Dec 1, 2009 at 08:05 AM
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?

1 reply

Answer 1 / 1
Trowa
Dec 1, 2009 at 08:05 AM
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
0