Results 1 to 2 of 2

Vlookup-- case sensitive

Threaded View

DawginAuburn Vlookup-- case sensitive 02-21-2012, 01:40 PM
Haseeb Avarakkan Re: Vlookup-- case sensitive 02-21-2012, 01:54 PM
  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

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