Update cell values based on drop down menu in a different cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2136428%22%20slang%3D%22en-US%22%3EUpdate%20cell%20values%20based%20on%20drop%20down%20menu%20in%20a%20different%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136428%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20cell%20C1%20to%20display%20either%201%20or%200%20based%20on%20the%20answer%20from%20a%20drop%20down%20menu%20in%20cell%20B1.%3C%2FP%3E%3CP%3EThe%20choices%20in%20the%20drop%20down%20menu%20is%20either%20%22Yes%22%20or%20%22No%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%20Select%20%22Yes%22%20in%20the%20drop%20down%20menu%20in%20B1%2C%20and%20then%20automatically%20get%20%221%22%20in%20cell%20C1.%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BSelect%20%22No%22%26nbsp%3B%20in%20the%20drop%20down%20menu%20in%20B1%2C%20and%20then%20automatically%20get%20%220%22%20in%20cell%20C1.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2136428%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2136474%22%20slang%3D%22de-DE%22%3ESubject%3A%20Update%20cell%20values%20based%20on%20drop%20down%20menu%20in%20a%20different%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2136474%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F967143%22%20target%3D%22_blank%22%3E%40asaetrang%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EHere%20is%20an%20example%20file%20with%20the%20result%20you%20specified.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAdditional%20information%20from%20microsoft%20via%20drop-down%20lists%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECreate%20a%20drop-down%20list%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fcreate-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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

@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-c5402dce4...

 

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.