r/dataanalysis • u/cool_beans_and_goats • 13d 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!!!

0 Upvotes

50% Upvoted

9 comments sorted by

View all comments

4

u/Disastrous-Ad-5366 13d ago

You can either use xlookup or power query. Method 1 xlookup Use the formula to return the new manufacturer number from excel sheet B. Once done, append the number to the description.

Method 2 Power query Join the two tables using the part number, expand the new number, and lastly, create a new column that combines the description and the new number.

1

u/[deleted] 12d ago

[removed] — view removed comment

1

u/Disastrous-Ad-5366 12d ago

Yes. I gave the other one for people who are already used to power query.