Dynamic dropdown list

Dear Sir,

Currently I am facing with dropdownlist problem.I have posted at http://www.excelforum.com/excel-form...alidation.html but could not be able get the desired solution.I think I might get solution at VBA forum hopefully.

As enclosed in attachment,I want result in F3 and G3.Currently I have shown single data in E3.There will be data in E4,E5,E6...... and so on.The data to be displayed in F3 and G3 should be in dropdown list which I tried using data validation but could not able to do so and omitted lateron.The lookup data are in A,B and C column.

Rest of the things I have explained in comment in F3 and G3.

Hope,I could able to achieve the result.

With Best Rgds,

Suresh