How to get one cell to change when another is picked from a list.

[Ringo71]

I want to get a cell that contains a zip code to automatically update when i pick a city from a drop down of local cities. The list of cities is on a separate sheet in a column with the corresponding zip code in the adjacent column. There are some that have multiple zips per city. Those cities have additional cells to the right. I am most concerned about the single cell if getting multiple zips is too complicated.

 

[enswitzer]

can you post a sample table? I want to make sure I understand what you are trying to do

 

[TheFailbird]

I think you can use a "combo box" to do that.

Add a list box or combo box to a worksheet - Excel

--TheFailbird--