Compare Data in Two Excel Sheets - Compare Two Worksheets Quickly

Опубликовано: 16 Март 2026
на канале: Excel Destination
4,122
69

This Excel Tutorial explains, How to compare data in two excel sheets with simple formula.
We can compare two data sets in 2 excel sheets using simple if formula.

Formula used in tutorial is : =IF(Sheet1!B2=Sheet2!B2,"True","Sheet1 : "&Sheet1!B2&"Sheet2 : "&Sheet2!B2)