Dependent Lookups

Hey.

New to the forum and I aint that good at excel :S

I'm looking for some help on dependent lookups and was wondering if I could get some help.

I have 6 columns

Site Name, Team Leader, Catchment, Area, Process

I have created a data validation drop down of these 6 column headers

I now want to create a dependent drop down that will show the distinct contents of the column I have selected in the first drop down. Presuming that Site Name is in cell A1 and each of the columns has the same amount of rows how would I go about this.

Many thanks in advance.

Try follow those instructions: http://www.contextures.com/xldataval02.html

Originally Posted by Marcol

See if this demo workbook helps.

It also has a link to a Contextures site for more information

That works an absolute treat, thanks. However... How do I get it to select distinct?

Thanks Again

What do you mean by "distinct"?

Post a sample of your workbook showing your lists and try to illustrate what you expect as a result.

Here is a modified copy of the previously posted example.

Notice that there are duplicate records appearing in the drop downs because of the duplicate entries in the list.

Is there anyway to remove these duplicate entries in the dropdown without removing them from the lookup lists.

thanks again

Originally Posted by Marcol

Why do you have duplicates? This only complicates things unnescessarily.

Unfortunately this is one of those cases where my need for duplicates is taken as a given as, as present there is no way to get rid.