Excel Forum



Excel Magic Trick 400: Show List of Values In Cells After Using Data Validation Drop-Down


See how to use Data Validation Drop-Down List to show a list of values in cells not just one value in one cell, but many values in many cells. See the IF, ROWS, INDIRECT functions in a formula and Data Validation Drop-Down List.





Got a Question? Ask it Here in the Forum.