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...
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....
Steps to Implement in-cell validation with a resulting lookup
1/ Create a 2 column lookup table with your dataset. Lets assume its in cells F10:G15.
2/ Select the cell where you want the drop-down.
3/ Goto the Data==>Validation menu.
4/ Select "List" in the Allow dropdown.
5/ Check the "In-cell dropdown" option
6/ Make the source the first column of your lookup column.
7/ Click OK.
Declan
Don't forget to mark your Thread as resolved.
Take a moment to rate posts that you think are helpful
See the attached example of how it works, you just need to select the cells you want the drop box then under "Data" select data validation and choose "List" in the allow box.
Reply With Quote
Originally Posted by zach007
