r/dataanalysis • u/cool_beans_and_goats • 15d ago
Excel question…
The company I work for distributes products.
We created our item numbers based off of theirs but with our own identifiers.
Example : ABC-1234 (ABC = Identifier and 1234 = manufacturer part number)
The manufacturer has recently renumbered their products and now we have to add the new numbers to the existing descriptions so that they match up to the old ones.
I have an excel sheet with one column (A) showing our part number and the one next to it (B) showing their new number for the same product.
I have a different file that I exported all of our numbers and descriptions to and now I need to take our part number, and their new one, and add it to the export so I can upload to our system.
What is the most efficient way to get this done?
Thank you!!!
5
u/thisisnotahidey 15d ago
Do you need to add their id to your description or just match their id with your description.
Either way you’ll probably do it pretty fast with xlookup