Home

DATA VALIDATION FORMULA

%3CLINGO-SUB%20id%3D%22lingo-sub-271816%22%20slang%3D%22en-US%22%3EDATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271816%22%20slang%3D%22en-US%22%3E%3CP%3EI%20AM%20USING%20THE%20FORMULA%26nbsp%3B%3DIF(F4%3DM5%2C%22MALE%22%2C%22FEMALE%22)%20WHERE%20F%20COLUMN%20IS%20GENDER%2C%20M5%3DM%20BUT%20THE%20FORMULA%20DOES%20NOT%20WORK.%20IM%20TRYING%20TO%20MAKE%20IT%20SO%20WHEN%20I%20INPUT%20M%20IT%20GIVES%20ME%20MALE%20AND%20WHEN%20I%20INPUT%20F%20IT%20GIVES%20ME%20FEMALE.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-271816%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-272101%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-272101%22%20slang%3D%22en-US%22%3E%3CP%3EYour%20intent%20is%20a%20little%20unclear.%26nbsp%3B%20If%20you%20are%20using%20that%20formula%20in%20Column%20F%20or%20Column%20M%2C%20you%20are%20probably%20getting%20some%20sort%20of%20circular%20reference%20error.%26nbsp%3B%20If%20you%20are%20using%20it%20in%20some%20other%20column%2C%20then%20the%20cell%20will%20display%20the%20word%20MALE%20if%20the%20values%20of%20cell%20F4%20and%20M5%20are%20the%20same%2C%20otherwise%2C%20it%20will%20display%20the%20word%20FEMALE.%26nbsp%3B%20If%20you%20want%20one%20cell%20to%20read%20MALE%20or%20FEMALE%20based%20on%20another%20cell%20having%20the%20letter%20M%20or%20F%20(really%2C%20anything%20other%20than%20M)%2C%20then%20Mr.%20Kim's%20formula%20will%20work%2C%20just%20keep%20in%20mind%20that%20whatever%20cell%20you%20paste%20it%20in%2C%20cell%20M5%20is%20the%20cell%20it's%20looking%20for%20the%20letter%20M.%26nbsp%3B%20If%20you%20are%20trying%20to%20get%20it%20to%20change%20based%20off%20the%20first%20letter%20you%20start%20to%20type%2C%20the%20Data%20Validation%20List%20suggestion%20will%20probably%20work%20for%20you.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271846%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271846%22%20slang%3D%22en-US%22%3Etry%3A%3CBR%20%2F%3Ein%20cell%20F4%20%3DIF(M5%3D%22M%22%2C%22MALE%22%2C%22FEMALE%22)%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-271845%22%20slang%3D%22en-US%22%3ERe%3A%20DATA%20VALIDATION%20FORMULA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-271845%22%20slang%3D%22en-US%22%3E%3CP%3Eplace%20the%20Data%20Validation%20on%20the%20cell%20that%20you%20prefer%20-%20then%20type%20on%20the%20source%20Male%2C%20Female%3C%2FP%3E%3CP%3Eyou%20can%20now%20have%20a%20selection.%3C%2FP%3E%3CP%3Epls%20see%20attached%20image.%3C%2FP%3E%3CP%3Ehope%20you%20can%20make%20something%20out%20of%20it.%3C%2FP%3E%3CP%3Ethanks..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F56514iFEC4EC986C91A84E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22DV-list.jpg%22%20title%3D%22DV-list.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Seth Krukowski
Occasional Visitor

I AM USING THE FORMULA =IF(F4=M5,"MALE","FEMALE") WHERE F COLUMN IS GENDER, M5=M BUT THE FORMULA DOES NOT WORK. IM TRYING TO MAKE IT SO WHEN I INPUT M IT GIVES ME MALE AND WHEN I INPUT F IT GIVES ME FEMALE.

3 Replies

place the Data Validation on the cell that you prefer - then type on the source Male, Female

you can now have a selection.

pls see attached image.

hope you can make something out of it.

thanks..

 

DV-list.jpg

try:
in cell F4 =IF(M5="M","MALE","FEMALE")

Your intent is a little unclear.  If you are using that formula in Column F or Column M, you are probably getting some sort of circular reference error.  If you are using it in some other column, then the cell will display the word MALE if the values of cell F4 and M5 are the same, otherwise, it will display the word FEMALE.  If you want one cell to read MALE or FEMALE based on another cell having the letter M or F (really, anything other than M), then Mr. Kim's formula will work, just keep in mind that whatever cell you paste it in, cell M5 is the cell it's looking for the letter M.  If you are trying to get it to change based off the first letter you start to type, the Data Validation List suggestion will probably work for you.