Im trying to compare last years price sheet to this years and note the
changes in the cost. I dont know how to do this.

I have two different methods set up but I cant seem to get them to work.

Method one is that I have two price sheets with identical headers and
columns. My part number on sheet 1 would be the same as the part number in
sheet two. Is there a way to compare the two sheets and place a value or
statement showing Increase in another column on the newest sheet?

Sheet one (old price list)
A B
Part Number Cost

Sheet two (new price list)
A B C D
Part Number Cost Increase Difference

Method two is that Ive combined the data from both spread sheets and sorted
them.
My value in column A is my part number; my value in column B is my cost. I
need to know is if my cost increased and place the change in a new row
indicating the change.

Here is what the sheet would look like
A B C D
2522 33.05 2008
2522 31.22 2009 Decrease
2523 10.00 2008
2523 12.00 2009 Increase
2524 10.00 2008
2524 10.00 2009 Same

Can this be done? I hope this makes sense!

Thank you.