I'm using Excel 2002.

I know how to create a drop down list to look-up information.
What I want to do is make a selection from one list that will let me make a
selection from a second list. For example, list one is a list of clients,
based on the client I select, I want to go to a the second list which
contains references related to only to the selected client. There would be
many clients, each having it's own list of many references.
--
JP

Jenny

Sounds like you want a dropdown item to generate a second dropdown.

See Debra Dalgleish's site for "dependent dropdowns using Data Validation"

http://www.contextures.on.ca/xlDataVal02.html




On Wed, 6 Dec 2006 10:38:02 -0800, Jenny Pepper
wrote:

I'm using Excel 2002.

I know how to create a drop down list to look-up information.
What I want to do is make a selection from one list that will let me make a
selection from a second list. For example, list one is a list of clients,
based on the client I select, I want to go to a the second list which
contains references related to only to the selected client. There would be
many clients, each having it's own list of many references.

Gord Dibben MS Excel MVP

In reviewing this site, I'm not sure it's exactly what I need.

Using my example, the first list of clients is actually a list of the
columns (one per client). Each column contains references for that client
only. So by selecting from the first list, the column is found and the
references for that client are displayed in the second list. I think this is
different from the directions at the referenced site in that there is more
than one column for the first drop down list to choose from.

I appreciate any help I can get!
--
JP


"Gord Dibben" wrote:

Jenny

Sounds like you want a dropdown item to generate a second dropdown.

See Debra Dalgleish's site for "dependent dropdowns using Data Validation"

http://www.contextures.on.ca/xlDataVal02.html




On Wed, 6 Dec 2006 10:38:02 -0800, Jenny Pepper
wrote:

I'm using Excel 2002.

I know how to create a drop down list to look-up information.
What I want to do is make a selection from one list that will let me make a
selection from a second list. For example, list one is a list of clients,
based on the client I select, I want to go to a the second list which
contains references related to only to the selected client. There would be
many clients, each having it's own list of many references.

Gord Dibben MS Excel MVP