I have done a lot of dropdownlist project for my own used for different criteria. If using 2007, sometimes it does not work with 2010 and vice versa.
I had never used macro for my project thus, this kind of formula i used will be able to be applied without enabling macro which is sometime annoying to a certain people. I also used dropdownlist for my teaching so that if i were given a question, i would simply open my file, select data from dropdownlist, key in some value and the answer appear directly.
To solve these kind of problem, i need your clarification on how you want the result appeared in the result cell. If you could show an example, it would be great!!!. I am looking forward for this job.
If you gladly award this job to me, i would be ery HAPPY !! and FEELING AWESOME coz i could help you and this would be my FIRST job freelancer.com
I'm hoping and looking forward to work with you. I wish that with my help, you/ your company will flourish in the future!!!!. Bye!!!