Hi all excel wiz!

I have 2 spreadsheets that has the same data, but input by 2 different
people, so I'm trying to find out the discrepancies between the 2
spreadsheets.

if there are 3 columns in the spreadsheets: Plant Date QTY

How can I use excel to match the data in the 3 columns?

I have tried index,match,sumproduct, but no luck!

All help/comments are very much appreciated!

THanks!