Name List
ABC
DFR
THY
UIJ
MNO


Names | Num
ABC | 1234
ABC | 5465
ABC | 87654
ABC | 98798
DFR | 87987
DFR | 896
DFR | 54654
THY | 97987
THY | 645487
THY | 54
THY | 897
UIJ | 849
UIJ | 48943
UIJ | 98753
UIJ | 879
MNO | 498
MNO | 79/65

I have 2 drop downs, where 1st one will display Name List and the 2nd one
the corresponding numbers of the name.

How to get all the corresponding numbers of a particular name as per drop
down one in a list box (control toolbar)

If these dropdowns are on a worksheet, you could add an extra column with just
the unique names. And then use Data|Validation.

You'd use that extra column for the source of the first data|validation
dropdown. You'd have to name the ranges that contain the numbers for each name
nicely, too.

Debra Dalgleish explains it:
http://contextures.com/xlDataVal02.html

Kash wrote:
>
> Name List
> ABC
> DFR
> THY
> UIJ
> MNO
>
> Names | Num
> ABC | 1234
> ABC | 5465
> ABC | 87654
> ABC | 98798
> DFR | 87987
> DFR | 896
> DFR | 54654
> THY | 97987
> THY | 645487
> THY | 54
> THY | 897
> UIJ | 849
> UIJ | 48943
> UIJ | 98753
> UIJ | 879
> MNO | 498
> MNO | 79/65
>
> I have 2 drop downs, where 1st one will display Name List and the 2nd one
> the corresponding numbers of the name.
>
> How to get all the corresponding numbers of a particular name as per drop
> down one in a list box (control toolbar)

--

Dave Peterson