Greetings!

Maybe someone could help me out here. I'm looking for an easy way of comparing two different sheets of data and recording their differences. For instance, I want to compare a list of item numbers and prices and see exactly which prices have changed from one sheet to the next. Here's an example:

Sheet 1 (Let's say that this is my current prices, ITEM and PRICE are two separate columns)

ITEM PRICE
ITEM1 2.00
ITEM2 7.70
ITEM3 4.00
ITEM4 5.10
ITEM9 11.50

Sheet 2 (These would be the new prices, ITEM and PRICE are two separate columns)

ITEM PRICE
ITEM5 9.50
ITEM3 4.50
ITEM9 11.50
ITEM1 1.75
ITEM2 6.80

Now, as you can see, both sheets do not contain the same information and are out of order. Item4 is missing from Sheet 2 and Item5 is missing from Sheet 1. These should be ignored. Also, it should not matter where in either sheet the data is located. What should happen is that the following items and new prices should be copied to sheet 3:

ITEM1 1.75
ITEM2 6.80
ITEM3 4.50

Notice that ITEM9 was not copied over. This was because the price did not change. If the price has not changed, I would like to ignore it.

I attempted to do this with VLOOKUP but couldn't figure out exactly how to do all of this. My assumption is that a macro would probably be an easier way to do this. Any suggestions?

Thanks!!