Use `=A1=B1` to check whether two cells match
Use `=EXACT(A1,B1)` to compare text with case sensitivity
Use `=IF(A1=B1,”Match”,”No Match”)` to return a custom result
Use Conditional Formatting to highlight duplicate or different values
Use `=COUNTIF($B:$B,A1)>0` to see whether a value in one column exists in another
Use `=IF(COUNTIF($B:$B,A1)>0,”Found”,”Not Found”)` to label matches
Use `=A1-B1` for numeric comparisons
Use `=IF(AND(A1=B1,C1=D1),”Match”,”No Match”)` to compare multiple columns
Use Power Query to merge and compare columns from different tables
Use the Filter feature to show matching or non-matching values
Use `=SUMPRODUCT(–(A:A=B:B))` to count matches across two columns
Use `=XLOOKUP(A1,B:B,B:B,”Not Found”)` to compare against another column
Use `=VLOOKUP(A1,B:B,1,FALSE)` to find whether a value exists in another column
Use `=IF(ISERROR(MATCH(A1,B:B,0)),”Not Found”,”Found”)` to test for matches
Use `=MATCH(A1,B:B,0)` to locate the position of a matching value
Use `=LEFT`, `=RIGHT`, or `=MID` before comparing if only part of the text should be checked