Multi Dependant Data Validation

[exlove]

I Have data in Three Columns like
In A coloumn Data is as follow
A
B
C
D
E

in B Coloumn following data is connected with A
A1, A2, A3
B1 , B2,
C1,
D1, D2, D3, D4

in B Coloumn if I select A1 then following data should appear for selection in Dropdown
In C1
AA101, AA102, AA103, AA104, AA105

So in this way I need dependant dropdown data validation for
3 Stages

Please find attached file how i need data through
Dropdown

[Ace_XL]

This thread might help..

http://www.excelforum.com/excel-gene...l-entries.html

[exlove]

No its depend on Colour
And I filled colur only for your understanding
Please help

[JBeaucaire]

Here's a way to do this. On your sheet1 you need the first main list of main_groups. Then a two-column table for each dependent section. IN the dependent tables you list all the options in column 2, then the main_group item that controls it in column 1. Then you sort each table by column 1 so all items are grouped.

Then on Sheet2... you use basic data validation for column A that uses your Main_Group.
The Data Validation in column B is dynamic. It's an OFFSET() formula that finds your Main_Group selection in the first column of the SUBGROUP table, then makes a list of all the matching items in column 2 of that table.
Column C works the same way except on the TASK table.

[exlove]

Thanks Buddy
You Are Jem
God Bless You
Just Tell me in My File why cant we do the same with indirect function.

[JBeaucaire]

Because the indirect isn't as powerful as you need.