There are at least two options:

1. AutoFilter - this presents the user with a pull-down list. All the user has to do is check the desired ID and the other associated daa will be displayed.

2. VLOOKUP() formulas also allow the user to enter an ID and have the assoicated data displayed.