excel has a wonderful feature now that is searchable drop down list which has really made our work quite easily let's create it go to data tab and choose data validation and instead of any value pick list and specify your source information here we are taking name as a source permission okay now you have your list which can display your values easily whether they are in the beginning middle or at the end like this you can see you can search for any value easily now [Music]