Data Validation based on 2 other data validations

**mtwa1990** · 05-06-2020, 02:49 PM

I can create 2 dropdown boxes so the second will only show data based on what was selected in the first dropdown by putting them in two lists etc

I am trying to use 3 dropdown boxes in a row (A B and C) each one showing different data based on whats selected in the previous dropdown.
The 3rd row (D) will then automatically display a result that can be edited.

Im not sure if it would be easier using a userform, if thats the case i dont know how to link the dropdown boxes like in data validation.

Any help on how i can make this happen would be much apreciated

Thank You

**Bo_Ry** · 05-06-2020, 03:21 PM

Unique lists for each Dropdown is needed.
The easiest way is Pivot table.

DV list for
F2
=OFFSET($J$2,,,COUNTA($J$2:$J$24))

F4
=OFFSET($M$1,MATCH(F2,$L$2:$L$24,),,COUNTIF($L$2:$L$24,F2))

F6
=OFFSET($Q$1,MATCH(F4,OFFSET($P$1,MATCH($F$2,$O$2:$O$24,),,20),)+MATCH($F$2,$O$2:$O$24,)-1,,COUNTIFS($O$2:$O$24,F2,$P$2:$P$24,F4))

F8

Formula:

Please Login or Register  to view this content.

Data Validation based on 2 other data validations

LinkBack

Thread Tools

Rate This Thread

Display

Data Validation based on 2 other data validations

Re: Data Validation based on 2 other data validations

Thread Information

Users Browsing this Thread

Similar Threads

Restrict data validation list selection based on another table - dependent data validation

If statement based data validation? Dynamic data validation?

Multiple data validations based on user input?

return data from table based on 3 dependant data validations

Multiple data validations for a data entry spreadsheet

Validations Based On Previous Validations

Hide/unhide button based on data validations

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions