Corresponding numbers in a list box

  • Thread starter Thread starter Kash
  • Start date Start date
K

Kash

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
 
Back
Top