3 Ways To Compare Data In Excel

For example, if the two columns you want to compare start on A2 and B2, highlight C2.

=IF(A2=B2,“Match”,“No match”)

You can disable this feature by clicking the Synchronous Scrolling button in the View tab.

=IF(Sheet1!A1<> Sheet2!A1, “Sheet1:"&Sheet1!A1&” vs Sheet2:"&Sheet2!A1, “”)

For example, A1 in Sheet1 is “Apples,” and A1 in Sheet2 is “Oranges. " A1 in Sheet3 will display “Sheet1:Apples vs Sheet2:Oranges” when using this comparison formula. [2] X Research source