Compare 2 lists and output unmatched items using array

Hi all - I have 2 sheets("Price1) and ("Price2"), which contain 3 columns (ColumnA "Date" , columnB "Item#" , columnC "Price"). I need to compare Item and Price in both sheets and output a list of unmatched item and price in column E.

Sheet("Price1")
Date Item# Price Unmatched Items
07/07/13 101 100.00
07/30/13 102 156.00
07/12/13 103 157.00
07/05/13 104 125.00
07/25/13 105 2,555.00
07/14/13 106 251.00
07/13/13 107 2,255.00


Sheet("Price2")
Date Item# Price Unmatched Items
07/07/13 101 100.00 108 252.00
07/30/13 102 156.00 109 252.00
07/12/13 103 157.00 110 85.00
07/05/13 104 125.00 111 26.00
07/25/13 105 2,555.00 112 245.00
07/14/13 106 251.00 113 5,625.00
07/13/13 107 2,255.00 114 25.00
07/03/13 108 252.00 115 256.00
07/15/13 109 252.00
07/05/13 110 85.00
07/21/13 111 26.00
07/08/13 112 245.00
07/12/13 113 5,625.00
07/19/13 114 25.00
07/29/13 115 256.00



Code needs help:

Please Login or Register  to view this content.

Try this:-

Please Login or Register  to view this content.

Regards Mick

MickG - Thank you for sharing your code. It works great, but it would be nice if you could kindly comment the steps and logic. Is it possible to tweak my code and make it work. It would be easier for me to follow my own logic.

This may help, Your code requires the Cols "B & C" to be combined to enable a comparison Between both sheets.I think it is possible but can gets quite complicated.

Please Login or Register  to view this content.

Regards Mick

Here's an alternative using ranges an arrays.

Please Login or Register  to view this content.

Regards Mick

Hi MickG - Thank you very much for your help and being patient with me. Are there any good books, video tutorial that you would recommend in getting over the vba learning curve?

There's lots of help out there , but I think its mainly logical thinking & practice.
I tend to store odd pieces of helpful code for later reference.