Drop down list: unique value's, values based on that choice, search values based on choice

Dependent drop downs require a bit of preparation.
The list in H2:H7 is populated using:

Formula:

=IFERROR(IF(MATCH(0,INDEX(COUNTIF(H$1:H1,Tabel1[Serie]),,),)>COUNTA(Tabel1[Serie]),"",INDEX(Tabel1[Serie],MATCH(0,INDEX(COUNTIF(H$1:H1,Tabel1[Serie]),,),))),"")

Copy (Ctrl + c) H2:H7 and paste as values > transpose (Ctrl + Alt + v) into cell J1
J2:L11 are populated using:

Formula:

=IFERROR(INDEX(Tabel1[[Type]:[Type]],AGGREGATE(15,6,(ROW(Tabel1[[Type]:[Type]])-ROW(Tabel1[[#Headers],[Type]]))/(Tabel1[[Serie]:[Serie]]=J$1),ROWS(A$1:A1))),"")

Select J2:J7, Press the Ctrl key and select K2:K4, press the Ctrl key again and select L2:L5
While the three ranges are select press the Ctrl, Shift and F3 keys
In the Create Names from Selection dialog box be sure that Top row is checked and select OK
The data validation for cell F2 is: =OFFSET(H1,1,0,SUMPRODUCT(--(H2:H7<>"")),1)
The data validation for cell F3 is: =INDIRECT(F2)
The formula for F6 is: =INDEX(Tabel1[Type],AGGREGATE(14,6,(ROW(Tabel1[Serie])-ROW(Tabel1[#Headers]))/(Tabel1[Serie]=F2)/(Tabel1[Weight]<=F5),1))
Let us know if you have any questions.