Compare 2 Columns, Copy to 3rd Column

[Danroid]

Hi All,

I am trying to do the following:
I have 2 text Columns I'm trying to compare. If they are equal to each other I need to copy the value from one of the columns to a 3rd column. Secondly if one column is null and the other is not. I need to then copy the none null column text to the 3rd column. I have no idea how to achieve this.
BASIC EXPLANATION
1. IF Column a = b, copy a to c
2. IF Column a is not null but column b is null, copy a to c
3. IF Column b is not null but column a is null, copy b to c
4. IF Column a is null and column b is null, insert text "MISSING" to column c

Any help will be much appreciated

[AliGW]

Welcome to the forum!

I think the first should be moot based on the rest. Try this in C1:

=IF(AND(A1="",B1=""),"MISSING",IF(A1="",B1,A1))

[Danroid]

Thank you !!!!

Your solution worked

[AliGW]

No problem!