Results 1 to 6 of 6

Case Sensitive Vlookup

Threaded View

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

    Case Sensitive Vlookup

    Hey yall,

    I am having a problem where vlookup will pull the wrong account number because some are "123a" and others are "123A" and it will not differentiate. Any ideas? I don't know if vlookup can do this or not.

    I attached an example where I know account number, phone, and contact. But it is pulling the wrong info over because it will not do an exact match. Any ideas? Thanks so much for the help!
    Attached Files Attached Files
    Last edited by DawginAuburn; 05-11-2012 at 03:26 PM.

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