Dependent validation list with table as source

[rickbisselink]

Hi all,

Could not find the solution elsewhere that combines my following questions, so I hope one of you has the solution!

I am trying to dependent validation list, where the source data is in one table (A1:C14). The table headers are generic and so cannot be used to refer to for the second validation list. The values in each of the columns in the table are not unique, so the validation lists need to have distinct values. Please find below my (test) worksheet, the validations would go into cells E2, F2 and G2, where F2 is dependent on E2 and F2 is dependent on E2 and F2.

Hope I'm making myself clear, thanks for your responses!

Kind regards,
Rick

Book1
	A	B	C	D	E	F	G
1	Day	Name	Product		Day	Name	Product
2	Monday	John	Apple
3	Monday	John	Pear
4	Monday	Peter	Orange
5	Monday	Peter	Banana
6	Monday	Steve	Kiwi
7	Tuesday	Karen	Orange
8	Tuesday	David	Mango
9	Tuesday	Jane	Tomato
10	Wednesday	Peter	Strawberry
11	Wednesday	Ryan	Kiwi
12	Wednesday	Karen	Lemon
13	Wednesday	Anne	Raspberry
14	Wednesday	Tom	Lemon
Sheet1

 

[MickG]

You're welcome