event

M

marker68

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.
 
G

Gav123

Hi,

Have a look at Vlookup in help...

Maybe that is something you can work with.

Gav.
 
Top