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