How can I compare the part numbers on one excel sheet to the inventory on another?

by on November 28, 2012

Q: I have two excel spreadsheets I need to compare, one is a list of part numbers, and the other is a list of inventory. I need to find out if the list of part numbers corresponds with the inventory list and mark what in the inventory list was on the list of part numbers. There are over 4000 rows so it needs to be something done quickly and easily.


One Response to “How can I compare the part numbers on one excel sheet to the inventory on another?”
  1.  

    I suspect what you are going to need to use is the vlookup function.

    This allows you to match a key in one row to the same key in another row to get a given value. The problem here is that you need to have the same key, or in your case maybe a product id or inventory id, in both sheets. Without knowing exactly what your sheets look like it is hard to give an example that will work though.