I would like to create a spreadsheet with a list of people and then put in all the zip codes in a 20-mile radius from their home. I would like to then be able to have a lookup box - type in a zip code and it pull up all the people in the list that have that zip code in their radius. Is this possible?
-
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.
Match zip code to a specific person in spreadsheet
- Thread starter AGlinskei
- Start date
igold
Well-known Member
- Joined
- Jul 8, 2014
- Messages
- 3,323
- Office Version
- 365
- 2010
- Platform
- Windows
I don't have an Excel solution for you, but this is a nice website for many Zip Code Lookups and more. They have been around a long time...
Home | Melissa Lookups
Free Lookups for person, ZIP Codes, maps, ZIP+4, carrier routes, addresses, reverse phone, IP location, SIC codes, street names, property info and much more.
www.melissa.com
Upvote
0
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,104
- Office Version
- 365
- Platform
- Windows
Give us a sample workbook and we can show you a solution.
Upvote
0
Similar threads
- Question
- Question
