Hi,

I got a column (C) containing a POSTAL CODE and column (D) CITY TO. If the postal code is "A0G" then I want the D column to be "GASPE". IF the C (postal code) column is NOT "A0G" I want the D column to retain its current value... I did a SUBSTITUTE in my form. Check line 14




=SUBSTITUTE(C14,"A0G","GASPE")



But if the C column is NOT "A0G" then the D column SHOULD NOT GET overwriting. UNKNOWN should stay in the D column IF C column is NOT "A0G".

Should I use SUBSTITUTE or other function to accomplish this?

Thanks in advance.

test_substitute.xlsx