Multiple Dependant Dropdown lists - need to show unique values only please

Hi there.

I have a worksheet (see attached) where there are 4 colums of data on the worksheet "Ref" .. just a subset of the data will add the rest later
L0 L1 L2 L3

Each column has differing values

On the "Table" worksheet I would like to see the drop down lists as I have set up.

So if I select a value in L0, I can only see the corresponding items from L1 etc.. in all columns

This is working ... however I can not work out how to only display unique values.
So where ESS is repeated multiple times in L0 it shows it in the dropdown multiple times. Is there a way using formulas to do this across the 4 lists?

Thank you :-)

Hi,

kindly enter a sample of u r expected results in Table Sheet Manually for different conditions .

Punnam

@ parsonsamie ,

I am trying to find the logic which will match requirement , but i am not sure weather i am going provide or not.

Let me try .

Punnam

I appreciate you trying to help :-) Thank you very much

see the attached file.
i have set data validations in the third sheet , check if that is what u want ?

Hi Kmahesh,
Thank you for helping :-) This is not quite working as expected.
I was looking for the dependant drop downs. So

If I select "FI" in column L0,
THEN I only see "Master Fin Data" in column L1

As per the table on the worksheet "Ref"

Thank you for trying to help out. :-) I appreciate the effort.

Thanx
Amie