Forum Discussion

asaetrang's avatar
asaetrang
Copper Contributor
Feb 15, 2021

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 ...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Feb 15, 2021

asaetrang 

Here is an example file with the result you specified.

 

Additional information from microsoft via drop-down lists

Create a drop-down list

https://support.microsoft.com/en-us/office/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b?ui=en-US&rs=en-US&ad=US

 

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.

Resources