Excel - Compare spreadsheets and indicate matched data

  • Thread starter Thread starter debvan
  • Start date Start date
D

debvan

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.
 
I do this for employee rosters too. I would use a VLOOKUP with an IF-ISERROR
combo. The formula would look up the BOM part number and if it finds it on
the static page, it returns a message "scrapped" and if it doesn't find it,
it would retun an error, which could be cleaned to show a blank cell.
Something like (for 2003)

=IF(ISERROR(VLOOKUP(part_number, static page, col ref, FALSE),"part
scrapped","").
 
Peo, thanks for the website. I was able to use VLOOKUP for this but
appreciate knowing other resources for future reference.
 
Back
Top