+ Reply to Thread
Results 1 to 2 of 2

Vlookup-- case sensitive

  1. #1
    Registered User
    Join Date
    01-24-2011
    Location
    Auburn, AL
    MS-Off Ver
    Excel 2003
    Posts
    17

    Vlookup-- case sensitive

    I looked to see if someone had posted something about this but I cannot find it. I am using a vlookup command to do a simple match:

    =VLOOKUP(A2,CHOOSE({1,2},F2:F10,E2:E10),2,0)

    It works perfectly. However my data has exact same customer ID's and the only deferintation between the two is an upper or lower case symbol.

    For example:


    12345b
    and
    12345B

    The function does not see a difference between these two numbers. Is there a way to incorporate a way to tell the vlookup function to "see" the upper and lowercase B as two different sumbols? I attached a sample of what the problem is. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    365
    Posts
    2,243

    Re: Vlookup-- case sensitive

    Try...

    =LOOKUP(2,1/EXACT(A2,G$2:G$5),F$2:F$5)
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

+ 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