Cascading Validation List with INDEX and MATCH Functions

[paulfitz54]

Hi,

I'm using a cascading validation list to display Department and then sub-department information from a data table.
When I select the department from the first validation list only the relative sub-departments appear in the second validation list, the cascading validation list works.

I used the formula below to display the list from the sub-department

=IFERROR(INDEX(Curriculum!$D$2:$D$562,SMALL(IF((Search!$B$5=Curriculum!$C$2:$C$562),MATCH(ROW(Curriculum!$C$2:$C$562),ROW(Curriculum!$C$2:$C$562)),""),ROWS(Curriculum!$A$1:A1))),"")

D5 is where my sub-department validation list is

And this also works perfectly.

What I would like is to be able to display the full department list before selecting the sub-department?

Is this possible with the formula above?

Thanks in advance