I have two spend reports from two different years (Spreadsheet A = 2012, Spreadsheet B = 2013) I need to bump against each other to compare line items on certain products to compare savings.
Different products are uniquely identified on each spreadsheet by Vendor Item ID numbers.
Is there a way I can bump every Vendor Item ID "123C" on Spreadsheet A beside every Vendor Item ID "123" on Spreadsheet B to calculate savings on the new lower price?
I have roughly 15,000 items (total, not unique) on each spreadsheet. I have previously run this type of report in MS Access, but was wondering if it was possible to do in Excel.