Excel Forum



Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?


See 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.





Got a Question? Ask it Here in the Forum.