You can use an AutoFilter to display the data for the selected name.
There are instructions in Excel's Help, and he

http://www.contextures.com/xlautofilter01.html

wrote:
I have a list of about 50 people's names associated with data. Some of
the names are repeated up to five times. I'd like to creat a drop down
list so that a person can pick their name from the drop down list and
their data will be highlighted. The problems is that I would like to
take my large data list and somehow convert it into a down list with
having all the repeated names, just list one name per instance. Is
there a convenient way to do this?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html