Forum Discussion
Update cell values based on drop down menu in a different cell
Hi,
I want cell C1 to display either 1 or 0 based on the answer from a drop down menu in cell B1.
The choices in the drop down menu is either "Yes" or "No"
Example: Select "Yes" in the drop down menu in B1, and then automatically get "1" in cell C1.
Select "No" in the drop down menu in B1, and then automatically get "0" in cell C1.
2 Replies
Here is an example file with the result you specified.
Additional information from microsoft via drop-down lists
Create a drop-down list
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
