Compare A&B columns with C&D columns

[Steved]

Hello from Steved

I have 4 Columns of information

Compare A&B columns with C&D columns

If C&D differ from A&B display "False"

What would be the Formula for the above please.

Thankyou.

 

[JoeU2004]

Compare A&B columns with C&D columns
If C&D differ from A&B display "False"
What would be the Formula for the above please.

Perhaps one of the following equivalent formulas.

The following array formula (commit with ctrl-shift-Enter instead of Enter):

=AND(A1:A4=C1:C4,B1:B4=D14)

Alternatively, the following normal formula (commit with Enter as usual):

=SUMPRODUCT(AND(A1:A4=C1:C4)*AND(B1:B4=D14))>0


Note: These formulas display FALSE if the pair-wise columns differ. But
the formulas also display TRUE if the columns do not differ. You did not
specify the latter. If that is not acceptable, there is a simple fix. For
example:

=IF(SUMPRODUCT(AND(A1:A4=C1:C4)*AND(B1:B4=D14))>0, "")

 

[Steved]

Hello JoeU2004

I've gone with the Below

=AND(A1:A4=C1:C4,B1:B4=D14)

With the Above Can I have it Display "FALSE" in Red Text with a Yellow
Background please, or is there another formula that will allow this.

I Thankyou

Steved

 

[JoeU2004]

With the Above Can I have it Display "FALSE" in Red Text
with a Yellow Background please

Geesh! Next, you'll be asking for the world! Just kidding....

In Excel 2003, click on Format > Conditional Formatting, and select "Cell
Value Is", "equal to", FALSE. Then click on Format (in the Conditional
Formatting dialog box), and set Font Color (red) and Patterns (yellow).


----- original message -----

 

[Steved]

Thankyou.

Geesh! Next, you'll be asking for the world! Just kidding....

In Excel 2003, click on Format > Conditional Formatting, and select "Cell
Value Is", "equal to", FALSE. Then click on Format (in the Conditional
Formatting dialog box), and set Font Color (red) and Patterns (yellow).


----- original message -----