I have two spreadsheets that I need to compare. The common data is product
numbers. One spreadsheet will remain static but the other (bill of materials
- BOM) will be updated weekly. The static spreadsheet indicates parts to be
scrapped. I need to check the BOM spreadsheet to see if it contains any of
the scrapped part numbers. The second step is to then indicate those parts
as scrapped in a new column on the BOM spreadsheet.

I have some intermediate skills in Excel so an easy solution would be
appreciated.