Can I do this with drop down lists?

[DirtRoad]

I have 2 drop down lists built, one named TownList and the other named
ZipList. (These are small towns with only one zip code per town.)

Is there a way to automatically fill in the "Zip Code" field from the
ZipList when I select the "Town" from the TownList?

Thanks in advance.

 

[Frank Kabel]

Hi
have a look at the VLOOKUP function or for dependent listboxes:
http://www.contextures.com/xlDataVal02.html

 

[DirtRoad]

Frank,

Thanks for the Contextures.com link. Here's what I found on another board.

=INDEX(ZipList,MATCH(towncellname,TownList,0))


Thanks Again!
DirtRoad





Hi
have a look at the VLOOKUP function or for dependent listboxes:
http://www.contextures.com/xlDataVal02.html