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.