Excel, partial search for Vlookup

Discussion in 'Coding' started by zelle132007, Jul 14, 2010.

  1. zelle132007

    zelle132007

    Joined:
    Jul 14, 2010
    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
    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
    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: Coding
    Replies:
    4
    Views:
    1,318
    KGB-911
    Aug 26, 2004
  2. cmeyer
    Replies:
    0
    Views:
    1,232
    cmeyer
    Dec 15, 2005
  3. Ryk

    Excel vlookup issue

    Ryk, Jul 23, 2008, in forum: Coding
    Replies:
    1
    Views:
    870
    guest_9323wk
    Jul 24, 2008
  4. 04stockwellr

    2003|Excel|VLOOKUP

    04stockwellr, Dec 12, 2008, in forum: Coding
    Replies:
    2
    Views:
    851
    thanhtan
    Dec 13, 2008
  5. mjnms
    Replies:
    0
    Views:
    1,255
    mjnms
    May 28, 2010
  6. elvanace
    Replies:
    1
    Views:
    912
  7. leyn c
    Replies:
    0
    Views:
    892
    leyn c
    Feb 25, 2011
  8. smithb2

    Excel VBA to Newer Excel Version

    smithb2, Aug 19, 2013, in forum: Coding
    Replies:
    2
    Views:
    2,064
    smithb2
    Apr 28, 2014
Loading...