Searchable Drop-Down List in Excel - The Easy Way

Create a searchable drop-down list in Excel using the FILTER function. This is the easiest way to set up a searchable list. Download the file used in the video - https://www.computergaga.com/_excel/files/searchable-drop-down-list.xlsx Introduction to the FILTER function - https://youtu.be/kdl3mNEyIRE This video shows two examples of setting up a searchable drop-down list. The first example searches for what you type anywhere in the text of the list items. This is great when searching for people's names as you can search using the first or last name. The second example will test only the characters at the start. The example here is to search for countries in a list. When you type 'Ca' you want countries like Canada and Cambodia to appear, not South Africa although it does contain the letters 'ca'. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw