I am working with two large lists of product information from a manufacturer that I need to compare and match part numbers with. I have an old list from last year and a new one from this year and I need to be able to see what part number are still being offered, which ones are no longer being offered, and new part numbers being offered. I would also like to compare the final price column to see if the matching part numbers have increased in price, decreased in price, or stayed the same. I have tried the VLOOKUP function for comparison, but it still leaves me with a lot of extra manipulation to get the final result. I have attached a sample document with three sheets of data. The first sheet would represent last years data, sheet2 would represent this years data, and sheet3 would represent the final result.

Thank you for any help in advance. TestSheet4Comparison.xlsx