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/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео Searchable Drop-Down List in Excel - The Easy Way канала Computergaga