3 three CASCADING DATA VALIDATION (CATEGORY, DESCRIPTION and MODEL) PLEASE HELP ! ! ! ! ! ! Thank you and GOD BLESS....

[Brixton11]

Great Day to you ! !

I am Newbie in MrExcel.com Hope you Help me to Solve This Very2x Big Problem For Me T_T
i So Stress Regarding This Please Help Guy's



SEE THE PICTURE

SITUATION:
.. Earlier This worksheet is , CATEGORY and DESCRIPTION only, and its already Working, the Description (Offset or Match or Cascade Data validation to Category), that's why if you Click to the Category and Choose One Category, the Description is Ready to Choose One to the Description of the Categery ,.
.. After that i Decide to add a Field that "MODEL" cause i want to be Specific to Item BUT !

Here's BUT !
.. After i Add a Column that's "MODEL" the Model Cant Choose what's the DESCRIPTION'S MODEL, is the MODEL SHEETS
.. I want to Cascade Data Validation or Match the MODEL to DESCRIPTION,

QUESTION:
.. IS MY FORMULA IS CORRECT ? or Somethings Wrong, or we need to ADD Formula on this kind of Situation?

 

[Caribeiro77]

Check this out:

https://www.youtube.com/watch?v=5nb84p2wX-c

and think it's what you need..

 

[Brixton11]

Thank So Much Caribeiro77 :")
God Bless..

 

[Brixton11]

Cant Work Caribeiro77

.. I already using OFFSET and MATCH About this :"(



Anyway Thank Friend ^_^

 

[Caribeiro77]

In what way it's not working?

 

[Brixton11]

In what way it's not working?

Ahhmmm..

.. the Model Column is not the same in the Description's Model

.. Means Working But the Drop Down List is not the Model's of Description i Choose