Word in 1 column or both

[dmb41]

I have many rows with two columns:

A B C
BLUE 0
BLUE BLUE
0 0
0 BLUE
BLUE 0
BLUE BLUE
etc
.
.
.
I am looking for for C to put "BLUE" if there is "BLUE" in A or B or Both.

I tried =Match(if(A1,B1,0),"BLUE", "NO") but it will only work for the ones that are in both columns.

 

[Dryver14]

Try this

=IF(OR(A1="Blue",B2="Blue"),"Blue","")

 

[meldoc]

Hello

Try.

=OR(A1="BLUE",B1="BLUE")

 

[dmb41]

Thanks Dryver14 that's exactly what I was looking for.