| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to enter a zip code & get a result of which area it is
I want to be able to type the first two or three letters of a zip code into a
cell, and to get a result in an adjacent cell telling me which of my companies branches that zip code is covered by. Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to enter a zip code & get a result of which area it is
Check out the below link on 'Dependent Dropdowns from a Sorted List'
http://www.contextures.com/xlDataVal13.html If this post helps click Yes --------------- Jacob Skaria "Hatoof" wrote: I want to be able to type the first two or three letters of a zip code into a cell, and to get a result in an adjacent cell telling me which of my companies branches that zip code is covered by. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
| worksheet code area | Excel Discussion (Misc queries) | |||
| Zip Code/Service Area help | Excel Discussion (Misc queries) | |||
| adding a phone area code that is not there | Excel Discussion (Misc queries) | |||
| Integration/area under a curve VBA code? | Excel Worksheet Functions | |||
Hybrid Mode
