A vlookup will help you. Use the value from the dropdown to search the entire dataset.