Avatar of realzeroburn
 asked on

How do I replace the content of a cell with a lookup?

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:

PROD1XX        Apples
PROD2XX        Bananas
PROD3XX        Pears

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.

SoftwareMicrosoft ExcelVB Script

Avatar of undefined
Last Comment

8/22/2022 - Mon
Saqib Husain

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

You're awesome!  Worked Perfectly!!
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.