Dynamic Data Validation Question

[Jonathan43]

I have a two-page workbook. A sheet with tab. “LIST” holds a sort of dictionary: Column A holds technical terms. In a given Row, columns to the right of Column A hold related terms.

For Example:

LIST

	A	B	C	D	E
1	Decibel	Sound	Power
2	Die Bushing	Punch Holder	Die Shoe
3	Wing Die	Press	Ram	Pipe

In other words, “Wing Die” has related terms “Press,” “Ram,” and “Pipe.”

On a separate sheet of the workbook, with the tab “REQUISITIONS,” I have a form that needs to have a variable number of rows filled in.

In Column A every row has Data Validation in the form of a picklist defined as ='LIST'!$A:$A .

Columns B, C, D and E need a standard validation that I haven’t figured out yet.

I want the REQUISITIONS user to be able to pick a value for Column A in a given row and then have a picklist for each of columns B,C,D,E that depends on the value selected for Column A. I want that user to be able to make selections that are all or fewer of the dependent values, and to make them in any order the user wishes.

For Example, a user should be able to produce the following result:

REQUISITIONS

	A	B	C	D	E
1	Wing Die		Press
2	Decibel	Power	Sound
3

The question is, how can I make the validations for columns B-E dependent on the selection that the user made in that row for Column A?

 

[Fluff]

Duplicate to: Are dynamic data validations possible?

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.