inventory comparison

I have an excel spreadsheet with several columns of data, from over a thousand bikes scanned from a yearly inventory. I also have a second tab in the same workbook with the official inventory.

I want to compare the two spreadsheets, using the barcode column (in red) in each and produce a list, or simply highlight on the official inventory line items missing, with their internal for tracking purposes.Thanks for your help!

Gurus GO!