Automatically Filling cells with information

[easycape]

I'm trying to create a excel spreadsheet that will allow me to select a basketball team from a drop down list (which is already created) and when this team is selected it automatically fills the excel cells with the roster names(these names will be somewhere else on the sheet). I don't know what code I should be using to allow this to happen. Any help will be great.

Thanks
EasyCape <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[PKTEE]

Using Vlookup/Hlookup formula.