Hello. In XL 2007, I can select our office street addresses from a data
validation list in col b rows 8-27. I can also select a city the same way in
col c rows 8-27. I would like to populate col c rows 8-27 with the related
city based on the address selection in col b. There can be more than one
address in a particular city. Thank you.

Hi,

Have a look at Vlookup in help...

Maybe that is something you can work with.

Gav.



"marker68" wrote:

Hello. In XL 2007, I can select our office street addresses from a data
validation list in col b rows 8-27. I can also select a city the same way in
col c rows 8-27. I would like to populate col c rows 8-27 with the related
city based on the address selection in col b. There can be more than one
address in a particular city. Thank you.