list box problems
 

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?

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

"Bobby" wrote in message
...
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?

That worked a treat. Thank you very much for that

"Biff" wrote:

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

"Bobby" wrote in message
...
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?

You're welcome! thanks for the feedback.

Biff

"Bobby" wrote in message
...
That worked a treat. Thank you very much for that

"Biff" wrote:

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

"Bobby" wrote in message
...
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?