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.