Compare Entire rows in two sheets in - Excel
I have two sheet with same data and I want to compare entire row in two sheets.
On Sheet1 (old data)
Col A | Col B
1001 | My Val 1
2001 | My Val 2
3001 | My Val 3
On Sheet2 (new data)
Col A | Col B | Col C
2001 | My Val 2 | True
3001 | My new Val 3 | False
1001 | My new Val 1 | False