dropdown to filter another dropdown.

[abenitez77]

I have a list that I want to use to filter a dropdown. This is a sample of what i want to do



I have a tab that has 2 columns (in my spreadsheet it has around 45,000 rows):



vndnbr ponbr

1 345

2 444

2 567

3 321

4 789

4 298



In cell A1 I have a dropdown that shows me the list below vndnbr(1,2,2,3,4,4). I can select a value..say i select the first 2.

In cell B1, I want to have a dropdown that shows a dropdown list with the values (444,567) to choose from.

 

[SkipVought]

hi,

FIRST, your first dropdown LIST, needs to have a list of UNIQUE vndnbrs: 1,2,3 etc.

The list reference for your second dropdown will be an array formula, pointing to the table you posted, using NAMED RANGES...
[tt]
=OFFSET(vndnbr,MATCH(DropDown1,vndnbr,0)-1,1,COUNTIF(vndnbr,DropDown1),1)
[/tt]



Skip,

_{Just traded in my old subtlety...
for a NUANCE!}