Suppose 2008 sheet is named as Sheet1 and 2009 as Sheet2 and Cols A,B,C in
both contain item #, descriptions, and costs respectively.

In sheet1 enter this in D1
=VLOOKUP(A1,Sheet2!,A:C,3,False)
and copy down...

It will give you the updated price if the item is there in 2009 sheet or
#N/A if it is not found...

If you enter this in D1 of Sheet2
=VLOOKUP(A1,Sheet1!A:A,1,False)
It will give you #N/A if it is not present in 2008 sheet

=IF(ISNA(VLOOKUP(A1,Sheet1!A:A,1,False)),"Not found in 2009","Found in 2008")

wiil give you more meaningful message...

"sta1" wrote:

I have two spreadsheets that contain item #, descriptions, and costs. One is
from 1008 and the other is for 2009. There are 2460 rows of information in
the 2008 and 3586 rows of information. I need to compare the 2 sheets and if
the part # exists in 2009 then change the cost pricing in 2008 to newest
cost. Also there are obviously 1186 new item # in the 2009 sheet, is there a
way to have them separated if they don't match the 2008 so they can then be
added at a later time?