I'm using drop-downs to choose from a list of location names.

When a location is selected I would like to have cells below the drop-down to display the locations corresponding address which is stored/displayed in 6 or 7 cells.

What do I need to do?

I hope that make sense. Does anyone have an answer/suggestion to my question?

Thanks!

Paul