New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck.
In this Excel tutorial from ExcelIsFun, the 549th installment in their series of Excel magic tricks, you'll learn how to create a dynamic data validation drop-down list in a cell using either the Table / List feature or the OFFSET function. (See The VLOOKUP function and a dynamic range for that.)