Uploaded March 2017 | Updated September 2026, 1 hour ago

---

What can you do if your data validation drop down list is so long that you want to close Excel and never use it again?
00:00 The Problem: super long drop down list
00:34 The Idea: use keyword(s)
00:46 Ask Questions: don't jump into a solution! ask questions!!!
01:30 Solution 1 Pivot Table
03:23 Solution 2 List Search Add-in (from Excelcampus.com)
03:49 Solution 3 Array Formula (very scary!)
06:12 Solution 4 Non Array Helper Formula (not scary)
09:00 Solution 5 Advanced Filter