+ Reply to Thread
Results 1 to 4 of 4

How to join 2 lists based on Case Sensitive ID

  1. #1
    Registered User
    Join Date
    01-17-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    How to join 2 lists based on Case Sensitive ID

    I've 2 lists that contain similar info but 1 of the lists holds info I need to join
    I've a unique case sensitive id that I'd like to use to join the lists
    I usually use VLOOKUP but it is case insensitive and I cannot understand how to make it case senstitive

    The 2 lists are in 2 separate worksheets as they each hold a lot of data

    Any one able to help me?

    THanks

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,704

    Re: How to join 2 lists based on Case Sensitive ID

    Take a look at the EXACT function in XL Help.

    Hope this helps.

    Pete

  3. #3
    Forum Expert XOR LX's Avatar
    Join Date
    04-18-2013
    Location
    Turin, Italy
    MS-Off Ver
    Office 365
    Posts
    7,742

    Re: How to join 2 lists based on Case Sensitive ID

    Hi,

    Just to add to Pete's comment, you would be using something like:

    =IF(EXACT(VLOOKUP(B1,$D$1:$D$10,1,0),B1),VLOOKUP(B1,$D$1:$E$10,2,0),"No Exact Match")

    Regards
    Click * below if this answer helped

    Advanced Excel Techniques: http://excelxor.com/

  4. #4
    Registered User
    Join Date
    01-17-2014
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    9

    Cool Re: How to join 2 lists based on Case Sensitive ID

    Thanks that worked

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Highlight duplicate rows based on column A but be case sensitive
    By theblade24 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-18-2013, 06:14 PM
  2. [SOLVED] SUMPRODUCT Or SUMIF - In case of Case sensitive???
    By lifeisaspreadsheet in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-28-2012, 07:57 AM
  3. Replies: 4
    Last Post: 06-19-2011, 03:07 AM
  4. .Name case sensitive
    By CinqueTerra in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2006, 05:00 PM
  5. [SOLVED] Case Sensitive Duplicates in Lists
    By Dee Veloper in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-22-2005, 01:07 PM

Tags for this Thread

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