+ Reply to Thread
Results 1 to 4 of 4

vlookup similar values

  1. #1
    Forum Contributor
    Join Date
    03-16-2010
    Location
    Phnom Penh, Cambodia
    MS-Off Ver
    Excel 2003
    Posts
    208

    vlookup similar values

    Hi,

    I have the list of data in two different worksheets.
    First sheet is something like this

    ANGKANH
    KAB_PHLUK
    PHUM_PRAMMUOY_DAB
    KHNANG_TA_KONG

    And second sheet is something like below

    A41_2Gi_ANGKANH ID001
    A41_2Gi_KAB_PHLUK ID002
    A41_2Gi_PHUM_PRAMMUOY_DAB ID003
    A41_2Gi_KHNANG_TA_KONG ID004

    I would like to use vlookup to get ID from table2 to table1. Is it possible to ask excel to cheek if any values in the table1 are very much similar to the any values in the table2 then start vlookup?

    Thanks you very much for your time. Your comment will be very much appreciated.
    Thanks,
    sanlen

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    13,876

    Re: vlookup similar values

    Hi,

    Are all these values in a single column and do the values in the second sheet always have exactly 8 leading characters, e.g. "A41_2Gi_", and always have 5 trailing characters, e.g. "ID001", so that if you ignore these what's left will be a value in the first sheet?

    Please also add your location to your profile. It often helps when people are responding to know where you live.
    Rgds
    Richard Buttrey

    If this was useful then I'm pleased to have helped. If you wish to rate it click the small star icon below this post.

  3. #3
    Forum Contributor
    Join Date
    03-16-2010
    Location
    Phnom Penh, Cambodia
    MS-Off Ver
    Excel 2003
    Posts
    208

    Re: vlookup similar values

    Hi,

    I have the data which is similar to the attach file. Sorry, i should have attached this file since my first post.

    I want to get the ID from TABLE1 to put in TABLE2 if the name in both tables are very much similar. Each name in TABLE2 is always have 8 leading characters.

    i.e: KAB_PHLUK is very much similar to A41_2Gi_KAB_PHLUK, so it should get ID002.

    Thanks you very much for your time and thanks in advance for further advice you may give me.
    Attached Files Attached Files

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    18,847

    Re: vlookup similar values

    in b3 try
    =VLOOKUP("*"&A3&"*",$D$3:$E$10,2,FALSE)
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ 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