Try using the "Vlookup" functionality in Excel. There are a lot more details
under the Help file in Excel...just type "Vlookup"

Hope that helps - I'm not an expert on it, but know that it exists.

eawren" wrote:

I maintain a workbook containing packaging info (dimensions + weight) for
about 9000 items. If sizes are changed, I receive a spreadsheet from someone
else containing the updated data for a subset of those items. Is there a way
to compare item numbers (unique identifiers) and automatically copy over the
updated information?