SOLVED

Select a data from drop down list and will result a value of 1 to the selected name

%3CLINGO-SUB%20id%3D%22lingo-sub-2063413%22%20slang%3D%22en-US%22%3ESelect%20a%20data%20from%20drop%20down%20list%20and%20will%20result%20a%20value%20of%201%20to%20the%20selected%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2063413%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20problem.png%22%20style%3D%22width%3A%20494px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246624i78E3F14F27DCE6A9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20problem.png%22%20alt%3D%22excel%20problem.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHi%20everyone..just%20needs%20help%20with%20this%20problem%20of%20mine..%3C%2FP%3E%3CP%3EI%20need%20to%20have%20a%20value%20of%201%20on%20their%20name%20if%20selected%20in%20the%20drop-down%20list.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2063413%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-2063446%22%20slang%3D%22en-US%22%3ERe%3A%20Select%20a%20data%20from%20drop%20down%20list%20and%20will%20result%20a%20value%20of%201%20to%20the%20selected%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2063446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F930108%22%20target%3D%22_blank%22%3E%40dhurt1982%3C%2FA%3E%26nbsp%3BLike%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-01-15%20at%2008.19.28.png%22%20style%3D%22width%3A%20559px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F246629i7D4B461FDD69304F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-01-15%20at%2008.19.28.png%22%20alt%3D%22Screenshot%202021-01-15%20at%2008.19.28.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ewhere%20A3%20contains%20the%20drop-down.%20You%20can%20suppress%20the%20zeros%20if%20needed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2063452%22%20slang%3D%22en-US%22%3ERe%3A%20Select%20a%20data%20from%20drop%20down%20list%20and%20will%20result%20a%20value%20of%201%20to%20the%20selected%20name%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2063452%22%20slang%3D%22en-US%22%3Eyes..that's%20exactly%20what%20I%20want...%3CBR%20%2F%3Ethanks%20a%20lot.%3C%2FLINGO-BODY%3E
New Contributor

excel problem.png

Hi everyone..just needs help with this problem of mine..

I need to have a value of 1 on their name if selected in the drop-down list.

3 Replies
Best Response confirmed by dhurt1982 (New Contributor)
Solution

@dhurt1982 Like this?

Screenshot 2021-01-15 at 08.19.28.png

where A3 contains the drop-down. You can suppress the zeros if needed.

yes..that's exactly what I want...
thanks a lot.

@dhurt1982 

The attached does what you say; whether it does what you want is another matter.

The formula to display the 1s is

= SIGN(Name=validation)

The appearance is just number formatting.