Hi Guys,

I'm looking at trying to create dependents for drop-down lists so I can filter out certain information.

For example, I have groups categorized by customers that fall into a classification of A, B, C & D.

I have it set up based off of a table.
Creating an offset of this. 


=offset(Sheet1!$A$2,0,0,CountA(Sheet1!$A$2:$A$2000))
I created the index off of this.

=Index(Customer,MATCH(0,COUNTIF($A$1:A1,Customer),0))
I then created the appropriate name for the drop-down. "UniqueCustomer"
and added the drop-down list.

I created the offset for the customername.

=Offset(Sheet1!$D$2,0,0,COUNTA(Sheet1!$D$2:$D$2000))
And the index.

=Index(Customername,MATCH(0,COUNTIF($B$1:B1,Customername)+(Customer<>Sheet3!$D$3),0))
Now, I want to create another dependent that after you have selected the A,B,C or D, that a market comes into play that will also reduce the overall list of the customername.

I'm having trouble understanding the logic of tying the market into the customername based off of the list that is already populated when A, B C or D is selected. I cannot connect it to the A, B, C or D as the market options expand all 4 and wouldn't change anything.

Any help would be greatly appreciated.

Regards,

-Bob