Comparing rows between two sheets

**SpaceShuttle** · 05-25-2012, 08:33 PM

Greetings!

In an Excel workbook, there are two sheets, SheetA and SheetB, each of which are made of two columns and thousands of rows of numbers. SheetB needs to be compared against SheetA, and the differences to be shown in SheetC, as in the simplified screenshot here: http://i49.tinypic.com/28txtl1.jpg

Which Excel formulas and methods can do this? I've searched the forum and found some interesting ways to use the array functions, but couldn't figure out how it can apply to my case.

Regards.

**FDibbins** · 05-25-2012, 10:10 PM

it would be easier to help if you uploaded the sample file, instead of an image of it. however, a vlookup() will probably give you what you want.

Are the 2 columns of numbers on each sheet matched/paired? if so, try adding a helper column to concatenate them =A1&B1, copied down, for each sheet, and then do the vlookup based on that.

if you cant figure out how to do it, upload a sample and let me know, i will help you through it

**SpaceShuttle** · 05-25-2012, 11:04 PM

Yes, they are pairs, parent and child. SheetC pretty much needs to show the mismatches between SheetA and SheetB, and preferably not the equal matches. How would you use a vlookup in this situation?

Here is my sample spreadsheet: