Link to home
Start Free TrialLog in
Avatar of realzeroburn
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:

PROD1XX
PROD2XX
PROD3XX

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.

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of realzeroburn
realzeroburn

ASKER

You're awesome!  Worked Perfectly!!