Here's the situation. I have 2 excel sheets. On Sheet 1 is a column with a list of part numbers, for example:
On Sheet 2 are two columns, one with the part number, and one with the name. For example:
Sheet 1 has maybe a couple hundred items, but Sheet 2 has all the products, so a couple thousand.
How can I replace the column in Sheet 1 that says "PROD1XX" with "Apples" by looking up the information from Sheet 2? I'm not sure if you can do this from within just Excel- or if a script is required. Any solution would work though, I could also do this from a CSV with a text editor if that'd make it easier.