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?

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?