data validation based on multiple criteria

[brainfreeze2the]

I am searching for a solution

This is my problem:

I have 6 drop down lists, every drop down list depends on the previous on.

The first 2 were no problem, but the others are.

The first one is a type of material, the second the same, but based on the first, options are limited. I used an indirect function. Works fine.

The 3the drop down is the thickness of the material, I would like to use the first and second drop down as a criteria. I tried to use a INDEX / MATCH, but it say I use too many arguments.


There are 5 possible matches in material
(material1 - material1/ material2 - material1 /material3 - material2/material3 - material 3/material4 - material2)

If any of those matches are present show me the values in dropdown for match1 till match5
Every match should show me different dropdown values.

Material1-material1 has 1 value
material2-material1 has 2 values
material3-material2 has 1 value
material3-material3 has 1 value
material4-material2 has 7 values


I have a main table with: (different sheet)
column A Material1
Column B Material2
Column C Thickness1
Column D Thickness2
Column E Position
Column F Dimension
Column G LMB


Thanks in advance

 

[brainfreeze2the]

I have found a solution to my problem!
I used a pivot table and added slicers.
Does the same thing I wanted.