"Steved" wrote:
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=D1:D4)

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

=SUMPRODUCT(AND(A1:A4=C1:C4)*AND(B1:B4=D1:D4))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=D1:D4)) 0, "")