Excel Forum
Similar Content
Quickly Create a Huge List of Numbers in Excel
Tutorial: Quickly create a large list of numbers in Excel using the Fill Command.  This will save ...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
Highlight Duplicate Values in Excel
Tutorial: How to highlight duplicate values in a list. Also, how to arrange those values next to ea...

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.