Thanx for the prompt reply.

No sir,I did not want that formula.

I want in dropdownlist here in E3=2784.Now in F3 I want in dropdown unique value from B column that matches E3 = A column data.I want in a drop down in a sense that sometimes what happens A column data here for instance given 2784 has repeated 4 times in A column and B column has 4 times repeated apple, in reality it might be such that 3 times repeated apple and next 1 might be other .So,here I want to display unique values only.

Similarly the G column data based on selection of E and F column data.

Hope now it has been understood.If further information,kindly let me know.

With Rgds,
Suresh