Create contingent data validation list based hierarchy selection from List

Question

Let me attempt to explain.

The source data sheet:

Column A List of master contracts

Column B List of contracts associated with each master contract

In the results tab:

Using data validation I have setup so the user can select a contract from column A

In the next cell I want to setup data validation, where the user will only view and select from second tier contracts associated with the selection made in the previous selection

I know I can achieve this by creating a table with the high level contracts names in a row 1, with associated  contracts listed below  in each column and use Indirect function. However as my master list will update weekly I need a more flexible solution.

Any suggestion would be very helful, thank you

Answer 1

Hi,

Not sure of what you mean by "more flexible solution" but try this solution on my website - http://www.ashishmathur.com/secondary-validation-cell-entry-to-update-when-primary-validation-cell-changes/

Hope this helps.

Answer 2

You are welcome.

Answer 3

Thank you, very helpful