My Cost Changed? Need Help to find the changes Compare values form

E

ernie - willcox

I’m trying to compare last years price sheet to this years and note the
changes in the cost. I don’t know how to do this.

I have two different methods set up but I can’t 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 I’ve 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.
 
S

Sheeloo

You are on the right track
Method 1
In sheet2 (new prices) cell C2 enter this
=VLOOKUP(A2,Sheet1!A:B,2,False)
assuming Sheet1 is the name of the sheet with old prices
Copy the formula down till end of your data set
This will give you the Old prices in Col C of Sheet2 with (assuming) New
prices already in Col B
Now =B2-C2 will give you the increase(decrease)

Method2
Enter Old in Col C (all cells) of Sheet1 and New in Col C of Sheet2
Now combine both sheets, sort on Col A then Col C
This will put together the prices for a part no.
Now you can do this in D2
=B2-B3
and copy down

Now filter on New to get your list...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top