compare columns in 2 different excel sheets code example

Example 1: excel vba How to compare two entire rows in a sheet

MsgBox [and(1:1=2:2)]

Example 2: power bi compare two columns in different tables

Column = IF(RELATED('OtherTable'[ColumnB])=[ColumnA],1,0)