+ Reply to Thread
Results 1 to 4 of 4

(Urgent help) Replacing Product codes with Product name

  1. #1
    Registered User
    Join Date
    01-21-2016
    Location
    Mandalay
    MS-Off Ver
    MS office 2010
    Posts
    6

    (Urgent help) Replacing Product codes with Product name

    Hi,
    I am using excel for my business. It contains lots of invoice sheets. What I want to do is when I write a product code in the description column, it would automatically change it to full product name. I have been looking around in the internet a lot. But I could not find the solution. Please Help me.
    Last edited by yash.kedia; 02-04-2016 at 01:57 AM.

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: (Urgent help) Replacing Product codes with Product name

    You can use Vlookup formula for this. https://exceljet.net/excel-functions...ookup-function check this link for better understanding about Vlookup.

    If still you have trouble then share your spreadsheet with desired result.

    For uploading the workbook you can go to advance and the click on attachment link ( see the signature and uploading workbook tips)
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: (Urgent help) Replacing Product codes with Product name

    Assuming you have a table somewhere which lists the product code in one column and the description in the next column, then you could use a VLOOKUP formula to get the description from the product code. However, this formula cannot be in the same cell as the one in which you enter the code, as your input would over-write the formula. So, assuming that your table of codes is in columns X and that you input the code into cell A2, then you could have this formula in B2:

    =IFERROR(VLOOKUP(A2,X:Y,2,0),"")

    to return the description.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    01-21-2016
    Location
    Mandalay
    MS-Off Ver
    MS office 2010
    Posts
    6

    Re: (Urgent help) Replacing Product codes with Product name

    Hi There, thanks for the help. I will try and let you know

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Looking up new bar codes and matching to product.
    By rsuits in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-04-2014, 11:48 AM
  2. Refrencing product codes to get cost value
    By kegiannone in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-07-2010, 08:12 PM
  3. Replies: 6
    Last Post: 06-25-2009, 07:39 PM
  4. Adding descriptions to product codes
    By paulboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2009, 05:26 AM
  5. [SOLVED] I have two columns (A) and (G) that have like product codes however
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 08-07-2006, 01:05 PM
  6. Replies: 1
    Last Post: 08-04-2006, 03:25 PM
  7. Replies: 1
    Last Post: 08-04-2006, 03:25 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1