check it here

http://www.contextures.com/xlDataVal02.html



On Oct 17, 4:47*am, neostar77
wrote:
Hi,

I want to create a Drop Down menu in Excel.

After I create the Drop Down menu, and when I select a name from the drop
down menu, the name selected should populate or display the address
information of that name in the other columns i.e. 1 column for city, 1
country, 1 for postal code/zip, etc.

How do I go about doing that?