Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheet

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT539-550.xls See how to: 1)Add drop down by typing values in 2)Add drop down by selecting range on worksheet 3)Add drop down by naming range on different worksheet 4)Add a warning message 5)Check to see if data is valid 6)VLOOKUP function 7)Name a range 8)Check the list of Names Add Data Validation Drop-Down List To Cell List on Worksheet or Different Worksheet