Excel - Compare spreadsheets and indicate matched data
 

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.

Excel - Compare spreadsheets and indicate matched data
 

You can use the method from here to tag the parts

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

--


Regards,


Peo Sjoblom

"debvan" wrote in message
...
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.

Excel - Compare spreadsheets and indicate matched data
 

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","").
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Peo Sjoblom" wrote:

You can use the method from here to tag the parts

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

--


Regards,


Peo Sjoblom

"debvan" wrote in message
...
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.

Excel - Compare spreadsheets and indicate matched data
 

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

"Peo Sjoblom" wrote:

You can use the method from here to tag the parts

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

--


Regards,


Peo Sjoblom

"debvan" wrote in message
...
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.

Excel - Compare spreadsheets and indicate matched data
 

This worked well for me. Thanks for the guidance.

"M Kan" wrote:

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","").
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Peo Sjoblom" wrote:

You can use the method from here to tag the parts

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

--


Regards,


Peo Sjoblom

"debvan" wrote in message
...
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.