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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
> news:[email protected]...
> >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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> >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?
>>
>>
>>