You need to use Data Validation to create your drop down list....

see here for how: http://www.contextures.com/xlDataVal01.html#Create

Then you can use a Vlookup formula to get corresponding data from a table you have somewhere on the sheet.... see Vlookup in Excel help files for details.