Index with conditions

Copper 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