list box problems

B

Bobby

I have a drop down list box which lists 5 letters a,b.... so on, then i have
a list of 8 names i want to attatch to each letter, so what i need is when i
select on of the letters the apropriate list of names comes underneath, 1
name in each cell. Can anybody help please?
 
B

Biff

Hi!

If I understand you correctly....

Build a table using the letters as the header and then list the 8 names
associated with those letters down the columns.

Assume that table is in the range H1:L9. H1:L1 are the letter headers A, B,
C, etc.

The drop down is in cell A1. You want the names to be listed in A5:A12.

Select the range A5:A12.

Type this formula in the formula bar and when done enter it using the key
combo of CTRL,SHIFT,ENTER:

=IF(A1="","",OFFSET(H1,1,MATCH(A1,H1:J1,0)-1,8))

Biff
 
Top