+ Reply to Thread
Results 1 to 4 of 4

New corresponding column with different category names

  1. #1
    Registered User
    Join Date
    11-09-2019
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2018
    Posts
    2

    New corresponding column with different category names

    Hi everyone. New user here, so apologies if this sounds like a juvenile question. I've tried looking this up online, and can't seem to figure it out. Maybe I'm not using the right keywords, but here goes.

    I'm working on some pivot tables, but the column I need isn't available and I need to create a new one. Currently, one of the columns I have is a bunch of product codes. Each product code has a corresponding name, which I have on paper.

    For example, let's say this is Column A with the product codes:

    HB192948
    HB106805
    HX109581
    HB106805
    HB192948
    HR181758

    I need to match each code to the name, and create a new Column B to look like this:

    Chaser 9000
    Ramp Free
    Night Time 108
    Ramp Free
    Chaser 9000
    Free Agent New


    I figure I can just copy the entire produce code column and paste onto a new sheet and use Find>Replace, then copy and insert that new column back into my original sheet again. However, I'm wondering if there's a simpler, faster way to do this?
    Last edited by llaand19; 11-09-2019 at 03:49 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,646

    Re: New corresponding column with different category names

    If you have a table of codes and their corresponding names somewhere (let's say in columns M and N), then you could use this formula in B2:

    =VLOOKUP(A2,$M:$N,2,0)

    and copy this down.

    Hope this helps.

    Pete

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Excel 2007
    Posts
    18,646

    Re: New corresponding column with different category names

    Actually, you might have to change the commas ( , ) to semicolons ( ; ) in the formula, depending on your regional settings, as well as use the Dutch word for VLOOKUP.

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    11-09-2019
    Location
    Utrecht, Netherlands
    MS-Off Ver
    2018
    Posts
    2

    Re: New corresponding column with different category names

    That did it! Thank you Pete!

+ 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