cell B1 to show a "list option"

ok, i am new to this site so I am asking these question with a great amount of respect. I have been using Excel for a little over a year at my job. I maintain a database for a collection agency and use excel for various other tasks such as tracking our profit margins, loading data into the database etc, well ok now i am tryin to create something outside of work..... what i need to know and help with is i have 4 sets of criteria of data. they are name, how, when and a lock order, what i want to create is a way where ok if i have "NAME XX" in A1, i would like for cell B1 to show a "list option" where somebody could choose YES or NO, and if YES is choosen it turns B1 in to a pre determined value, if No is choosen it returns a value of "ZERO" . I can get the formulas to work but the actual graphical YES/NO i can not get that to appear ??? how do i do this ??? will also want it to continue where the same option is in cell D1 in relation to C1, and so forth for the 4 sets of data i have.... i guess its like a drop down box where u can choose yes/no and have diff values for YES and NO .......
Thank you guys very much for any assistance that you can provide

Brad

Originally Posted by EdMac

http://www.contextures.com/xlDataVal02.html

Post back if you need more help and preferably attach a sample of your work book.

Regards

ED thank you very much, I was able to create the drop down options, i will have the xls attached, but i still can not figure out how to assign a value to the YES or No, i want all "no" to equal zero, i would like for the YES's in column B to equal 4, and the "YES" in coloms D and E to equal 3. and once i can get the value for YES n NO defined, will it just overwrite the YES/NO in say B2 and make it a value of 4, or will the value have to be out putted into its own cell.

ED thanks again for your help