Create Data Validation List from Excel Table (3 Easy Ways)

Excel doesn't allow you to use structured references with in data validation dialog box, but there are some workarounds.

In this video I'm going to show you three easy workarounds you can use to use Excel table structure references within data validation dialog box

00:00 Intro
01:24 Using INDIRECT Function
02:53 Using NAMED Ranges
04:07 Using range reference itself

Read Article - https://trumpexcel.com/data-validation-list-from-excel-table/

☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - https://www.buymeacoffee.com/SumitB

✅ Free Excel Course (Basic to Advanced) - https://trumpexcel.com/learn-excel/
✅ Free Dashboard Course - https://bit.ly/free-excel-dashboard-course
✅ Free VBA course - https://bit.ly/excel-vba-course
✅ Free Power Query Course - https://bit.ly/power-query-course
✅ Best Excel Books: https://trumpexcel.com/best-excel-books/

Subscribe to get awesome Excel Tips every week: https://www.youtube.com/user/trumpexcel?sub_confirmation=1

#Excel #ExcelTips #ExcelTutorial #SumitBansal

Видео Create Data Validation List from Excel Table (3 Easy Ways) канала TrumpExcel