+ Reply to Thread
Results 1 to 3 of 3

Automatic Column Entry

  1. #1
    Registered User
    Join Date
    09-30-2010
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Question Automatic Column Entry

    Hi,

    I am trying to get a workaround for an issue, which will help me to save lot of time working on huge number of records. I have a worksheet having

    Column a (Product ID), Column b (Product Price), Column c(Sale Value)

    I need to put another column d, which will be the name of product matching to product ID, there will be several repetition across the sheet on monthly basis across many worksheets. How do I add product name relating to product ID?

    For e.g.
    ID Price Sales Product
    171a $12 $11 ItemA
    171a $12 $11 ItemA
    171a $12 $11 ItemA
    171b $12 $11 ItemB
    171b $12 $11 ItemB

    every time I have to paste the product name w.r.t to the ID

    Thanks in advance for any help

  2. #2
    Registered User
    Join Date
    04-19-2010
    Location
    New York
    MS-Off Ver
    Excel 2007
    Posts
    86

    Re: Automatic Column Entry

    I guess you could use a VLOOKUP.

    Create a table:
    Column A = Product ID
    Column B = Product Name

    Insert the data in this table for each product, call the table range 'products', then enter:

    Please Login or Register  to view this content.
    in cell D2, then copy it down...

    I think this would work.
    John

  3. #3
    Registered User
    Join Date
    09-30-2010
    Location
    Bangalore
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Automatic Column Entry

    Thanks for your reply,

    However, product name is what I need to keep on entering every time for each product ID.

    Suppose I complete one sheet with random ID and correct product name in front of it, How do I start in next worksheet, I have to keep entering the product name again for each ID

    I want product name to be available in the next row when I enter the product ID. As each ID is associated to a specific product.

    I hope I am able to explain myself

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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