Index with conditions

Question

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.

sergeibaklan · Answer

jfrjfr&nbsp;
That could be
=IF(C2="NO DESCRIPTION",D2,C2)

jfrjfr · Answer

SergeiBaklan&nbsp;It was&nbsp;=IF(C2&lt;&gt;"NO DESCRIPTION",D2,C2)BUT YES!!! You got it right, thank you very very very much&nbsp;

sergeibaklan · Answer

jfrjfr&nbsp;
Sorry for the misprint, glad to know you sorted this out

Forum Discussion

Index with conditions

3 Replies

Resources