Excel - Compare spreadsheets and indicate matched data

[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.

 

[Peo Sjoblom]

You can use the method from here to tag the parts

http://www.cpearson.com/excel/Duplicates.aspx

--


Regards,


Peo Sjoblom

 

[M Kan]

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","").

 

[debvan]

Peo, thanks for the website. I was able to use VLOOKUP for this but
appreciate knowing other resources for future reference.

 

[debvan]

This worked well for me. Thanks for the guidance.