Results 1 to 8 of 8

Need Case Sensitive VLOOKUP FOrmula

Threaded View

  1. #1
    Registered User
    Join Date
    08-05-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    6

    Exclamation Need Case Sensitive VLOOKUP FOrmula

    In the attach picture I'm trying to find exact match of the value in Column C with Column A and if it finds exact match (case sensitive) it should return the value in Column B.

    I've tried the following formulas but it's not working:

    =VLOOKUP(MAX(EXACT(D2,$A$2:$A$9)*(ROW($A$2:$A$9))),$B$2:$C$9,2,0)

    also tried =INDEX(data,MATCH(TRUE,EXACT(D2,A2:AXXX),0),3)

    Appreciate the help in advance.

    Capture.PNG
    Last edited by jobie804; 03-15-2017 at 02:19 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use Vlookup-Case sensitive
    By Terressa in forum Excel General
    Replies: 3
    Last Post: 07-15-2015, 02:57 AM
  2. [SOLVED] Case Sensitive Vlookup
    By DawginAuburn in forum Excel General
    Replies: 5
    Last Post: 05-11-2012, 03:39 PM
  3. Vlookup-- case sensitive
    By DawginAuburn in forum Excel General
    Replies: 1
    Last Post: 02-21-2012, 01:54 PM
  4. Case Sensitive Vlookup-How?
    By alfykunable in forum Excel General
    Replies: 4
    Last Post: 12-23-2011, 03:26 AM
  5. Case Sensitive Vlookup
    By VegasL in forum Excel General
    Replies: 4
    Last Post: 05-25-2010, 01:20 PM
  6. Vlookup Case sensitive
    By vinaynaran in forum Excel General
    Replies: 8
    Last Post: 10-16-2008, 11:21 AM
  7. Case sensitive vlookup
    By Tawe in forum Excel General
    Replies: 3
    Last Post: 06-13-2005, 10:43 AM

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