Excel, partial search for Vlookup

Discussion in 'Webmaster / Programming' started by zelle132007, Jul 14, 2010.

  1. zelle132007

    zelle132007

    Joined:
    Jul 14, 2010
    Messages:
    5
    Likes Received:
    0
    I'll spare you the details, but I believe that what I need to do is use a vlookup with range false for only a specific portion of the look up value, i.e. only the first 6 letters of the look up value looking for an exact match. Any Ideas??

    I can provide the long winded gritty details if you really want them.
     
    zelle132007, Jul 14, 2010
    #1
    1. Advertisements

  2. zelle132007

    ExcelChamp

    Joined:
    Aug 5, 2010
    Messages:
    2
    Likes Received:
    0
    Not sure I quite understand the situation, but in the file you are looking up values you could create a new column and extract the first 6 characters of the lookup value (i.e unique identifier) using this formula "=left(B1,6)" and then use the vlookup on that column.
     
    ExcelChamp, Aug 5, 2010
    #2
    1. Advertisements

  3. zelle132007

    zelle132007

    Joined:
    Jul 14, 2010
    Messages:
    5
    Likes Received:
    0
    Thank you for your help, I have since created an array that utilizes such a procedure.
     
    zelle132007, Aug 5, 2010
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.

Share This Page