Hi,

To "DKenny": Thanks for your reply...it was amazing...But, how to make "step by step" walktrough for in-cell validation on Cell B2 and then pass the selected value to a lookup fuction to return the propper value please..??? Because I could not saw behind its codes....

To "thelocaluk": Thanks for your reply...it was great and amazing...But, why when I saved it as "Save As Webpage"...It could not interactive anymore..???..it could not select the drop down menu...it look like a death spread sheet...

Thanks for your kind helps....