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.
Similar Threads
  1. KGB-911

    Search Box

    KGB-911, Aug 26, 2004, in forum: Webmaster / Programming
    Replies:
    4
    Views:
    1,234
    KGB-911
    Aug 26, 2004
  2. Ryk

    Excel vlookup issue

    Ryk, Jul 23, 2008, in forum: Webmaster / Programming
    Replies:
    1
    Views:
    813
    guest_9323wk
    Jul 24, 2008
  3. 04stockwellr

    2003|Excel|VLOOKUP

    04stockwellr, Dec 12, 2008, in forum: Webmaster / Programming
    Replies:
    2
    Views:
    794
    thanhtan
    Dec 13, 2008
  4. mjnms

    Search and copy a shape from another file using C#

    mjnms, May 28, 2010, in forum: Webmaster / Programming
    Replies:
    0
    Views:
    1,085
    mjnms
    May 28, 2010
  5. elvanace
    Replies:
    1
    Views:
    801
Loading...

Share This Page