Dependent lists

[pwatt01]

Gd'ay all. I have googled a bit for this answer, but can't seem to get anything to work. I have a worksheet which values are sourced from a database. This table looks like this: (i am actually using different names to make it easier)

Last name | First name | some personal details.

in this case there can be more then one last name the same, and more then one first name to be the same, but there will NEVER be someone with the same first and last name.


in another work sheet i want to get the personal details by using a validation drop down list to choose the last name, then another validation drop down list (based on last name) to get the first name, so when i am choosing the last name only the first names with corrosponding last names will appear.

Anyone with some idea on how to do this, as i have been having no luck in getting anything working.

Cheers

[zbor]

Hi,

please look at this link: http://www.contextures.com/xlDataVal02.html

[pwatt01]

Thanks for that, but i tried it and it desn't semm to do what i am after (if i did it correctly :-) )
The list i am looking at is like this:

Please Login or Register  to view this content.

Because it is in 2 rows, not a list for every last name, that INDIRECT method doesn't seem to work

Any other ideas???

[teylyn]

You need to filter out unique values for last name.
You will also need to filter out for each last name what the valid choices for first name will be.
Copy the unique values into their own columns and make these the source for your data validation.

Depending on how much data you have, this will be a lot of work.

Use Advanced filter to help with creating your unique lists.

[martindwilson]

well its late and im tired but you can do it this way