I have a list of various zip codes that occur in a dataset. I also have a list of all the place names of a certain range of zip codes. Is there any function that I can put next to the column of zip codes that occur in the data set that will match them to the names of places from the zip code list of place names?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Matching names to zip codes
- Thread starter eadlam
- Start date
barry houdini
MrExcel MVP
- Joined
- Mar 23, 2005
- Messages
- 20,825
Perhaps something like this
Formula in F2 copied down
=LOOKUP(2,1/((E2>A$2:A$7)*(E2< B$2:B$7)),C$2:C$7)
| Book1 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | zip | ziplist | area | ||||||
| 2 | from | to | Area | 12456 | Baltimore | ||||
| 3 | 12000 | 13000 | Baltimore | 45231 | Yellowstone | ||||
| 4 | 15000 | 18000 | Amityville | 89765 | #N/A | ||||
| 5 | 23000 | 28000 | Rhode Island | ||||||
| 6 | 33000 | 34000 | Raton | ||||||
| 7 | 40000 | 49999 | Yellowstone | ||||||
| 8 | |||||||||
Sheet 1 | |||||||||
Formula in F2 copied down
=LOOKUP(2,1/((E2>A$2:A$7)*(E2< B$2:B$7)),C$2:C$7)
Upvote
0
Similar threads
- Question
