Index with conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-2077974%22%20slang%3D%22en-US%22%3EIndex%20with%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2077974%22%20slang%3D%22en-US%22%3E%3CP%3EHey!%20I%20hope%20this%20is%20possible%20to%20be%20done%20with%20formulas%20and%20I%20really%20hope%20somebody%20here%20can%20help%20me!!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20need%20to%20put%20in%20column%202%20%22TEXT%22%20the%20information%20of%20column%203%20%22ENGLISH%22.%3C%2FP%3E%3CP%3EBUT%20if%20column%26nbsp%3B%203%20%22ENGLISH%22%20and%204%20%22SPANISH%22%20are%20equal%20I%20do%20not%20need%20any%20change%20in%20the%20column%20or%20%22error%22%26nbsp%3B%3C%2FP%3E%3CP%3EBUT%20if%20in%20column%203%20%22ENGLISH%22%2C%20it%20says%20%22NO%20DESCRIPTION%22%20then%20I%20need%20the%20value%20of%20column%204%22SPANISH%22!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20attached%20an%20image%20and%20the%20excel%20sheet!%20Thanks%20A%20LOT.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2077974%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-2078107%22%20slang%3D%22en-US%22%3ERe%3A%20Index%20with%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2078107%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F932222%22%20target%3D%22_blank%22%3E%40jfrjfr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20could%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DIF(C2%3D%22NO%20DESCRIPTION%22%2CD2%2CC2)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
New Contributor

Hey! I hope this is possible to be done with formulas and I really hope somebody here can help me!!

I need to put in column 2 "TEXT" the information of column 3 "ENGLISH".

BUT if column  3 "ENGLISH" and 4 "SPANISH" are equal I do not need any change in the column or "error" 

BUT if in column 3 "ENGLISH", it says "NO DESCRIPTION" then I need the value of column 4"SPANISH"!

 

I attached an image and the excel sheet! Thanks A LOT. 

3 Replies

@jfrjfr 

That could be

=IF(C2="NO DESCRIPTION",D2,C2)

@Sergei Baklan It was 

=IF(C2<>"NO DESCRIPTION",D2,C2)

BUT YES!!! You got it right, thank you very very very much 

@jfrjfr 

Sorry for the misprint, glad to know you sorted this out