Drop‑Down Lists From Tables: Stop Using INDIRECT (Do This Instead)

★ Get the example file ★ Sign up for our free Insiders program and get the example file: https://exceloffthegrid.com/insiders-... File Reference for this video: 0307 Data Validation - 1 Good Way ★ JOIN THE FREE COURSE ★ Want to get the free Modern Excel Formulas course? Click here: https://exceloffthegrid.com/modern-ex... ★ About this video ★ Learn the one method you should be using to create rock‑solid data validation drop‑down lists from Tables in Excel. Forget INDIRECT, named ranges, and workarounds; the spill range approach just works! In this video, you'll see how to build dynamic drop‑downs that auto‑expand, survive table renames, and never need fixing. We’ll also enhance the list using SORT, UNIQUE, FILTER, TOCOL, VSTACK, and LET to remove duplicates, hide blanks and errors, and control what users can select. 0:00 Introduction 0:34 Other Methods Fail 1:36 The One Good Way 4:39 The One Good Way Is Very Flexible 4:54 Sorting 5:38 Unique Values 6:20 Removing Blanks And Errors 7:27 Pre-filter the list 8:08 Add Items To List 9:42 Select Items Once 12:16 Wrap-up ★ Want to automate Excel? Check out our training academy ★ https://exceloffthegrid.com/academy ★ Download 30 most useful Excel VBA Macros ebook for FREE ★ https://exceloffthegrid.com/ ★ Where to find Excel Off The Grid ★ Blog: https://exceloffthegrid.com Twitter:   / exceloffthegrid   #MsExcel