try....

=vlookup(drop-down-cell-reference,range-where-your-data-is,column-you-want-to-look-in,fallse) the ,false is so you can look in an unsrted range

if this doesnt work for you, perhaps consider uploading a sample workbook?