Update an inventory list with new parts and pricing

It may be easier if you show an example with sample data and the results you are looking for. But you could: A) add the new inventory items in Sage (I believe there is an import function in Sage) B) Give a unique Prefix to identify the NEW PARTS not listed (this way you could have it's own lookup table if needed).
- You can get a list of duplicate items by way of Conditional Formatting which will highlight the duplicates.

So I had a thought while I was fixing the #N/A results from my Vlookup's:

If I go to the new sheet with the current price list, and use a vlookup type function
-I can't remember which one says 'this data(cell reference), in that table, exists or doesn't exist'
-then I can just copy/paste those rows into the current inventory sheet...

The new parts came out of SAGE in the "new pricing" spreadsheet. Now I need to add them to the existing inventory sheet - I copied last year's inventory workbook and cleared the quantity columns, then changed the pricing in the cleared sheet to vlookup formulas that look at the "new pricing" sheet I spit out of SAGE. Now I want to add parts from "new pricing" to the copied inventory sheets from last year's workbook. Because the formatting and categorizing and breaking up to make it look the way the accounting department needs it to look took me about 4 hours last year when I just formatted and broke up the "new pricing" spreadsheet last year... I want to avoid that by just adding the new parts from this year's "new pricing" sheet.