Excel 2007 : Drop Down Address List

I like to have a drop down list with the name of my vendors, when there names are selected from the list there address are filled in below them.

Name
Street
City, State, Zip
Phone
Fax

I have limited knowledge of Excel so please be easy on me. I figure some kind of index/match, or vlookup, but i can not find a good way of doing it. All of the address will be on a different worksheet, but same workbook.

Providing the data is correctly laid out you simply use VLOOKUP & Data Validation

http://excel-it.com/excel_functions.htm

http://excel-it.com/data_validation.htm