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.