Tom’s Tutorials For Excel: Comparing Lists For Identical Match
Here’s an example with the formula
=AND(A1:A10=B1:B10) that returns TRUE when all pairs of cells match in a two-column list, and FALSE when at least one pair is different in any way.
This is an array formula, where you need to enter it with Ctrl+Shift+Enter, not just with Enter. If you are new to array formulas, see my video and explanation of arrays here.
Leave a Reply