Comments on: 5 ways to do case-sensitive VLOOKUP in Excel

Comments page 2. Total comments: 42

1. 

   Bosozoq says:
   2016-12-03 at 7:17 pm

   help plz can i include =upper in =VLOOKUP(A4,List!A:AG,22,)

2. 

   maryam says:
   2016-01-05 at 8:56 am

   Thanks a lot.

3. 

   Maurizio says:
   2015-12-10 at 2:57 pm

   I was searching the way to make lookup case sensitive and I found this article, the INDEX/MATCH seems interesting however I cannot make it working, in particular the function "EXACT($B$2:$B$7,$G$2)" does not work with a range ($B$2:$B$7), it always compare only the first value ($B$2).
   Any hint please.

   1. 

      Jason K says:
      2016-07-29 at 3:42 pm

      So true! EXACT is not working with ranges for me at all. Somehow LOOKUP understands it, but MATCH certainly is not. It always returns #N/A.

4. 

   danish says:
   2015-09-14 at 4:33 pm

   Please tell me how can I apply vlookup in multiple columns at a time

5. 

   danish says:
   2015-09-14 at 3:51 pm

   M not able to understand vlookup

6. 

   Luna says:
   2015-07-03 at 12:14 pm

   I want to extract the duplicate list in a column. Please help what function to use. Thanks.

7. 

   Scout4u says:
   2015-04-23 at 2:19 am

   I found another formula online that worked!
   =LOOKUP(1,1/EXACT($A2:$A4,$C2),$B2:$B4)

   This came from this blog: http://stackoverflow.com/questions/7738097/exact-case-matching-with-excel-vlookups

   1. 

      Carmen Lee says:
      2019-11-15 at 1:57 am

      Thanks, this really helpful.

8. 

   Scout4u says:
   2015-04-23 at 2:09 am

   Hello Svelana,

   Your solution for Case Sensitive LOOKUP is not working for me. I've created a formula exactly as you have described and sorted the LOOKUP column A-Z.
   For some reason the results are skipping 3 rows of data and inserting the results of the 3 row down from the exact match?
   :(

9. 

   Plan B says:
   2015-01-14 at 4:09 pm

   Great article but try a proof-read or two next time, particularly when describing function names. :)

   1. 

      Svetlana Cheusheva says:
      2015-01-14 at 4:27 pm

      Always do. But somehow they manage to slip by me once in a while, sorry for that.

10. 

    Saif says:
    2014-12-04 at 9:36 am

    Thanks a lot Svetlana!

    I have been searching for a solution for quite some time now and I finally happen to stumble upon your article. This was of real help to me.

    Using CODE function was really out of the box thing which is best for resolving my issue. It helped me do a Case sensitive VLOOKUP on 15 digit Salesforce.com record IDs.

    The presentation was excellent as well.

    Thanks again!

    1. 

       Scout4u says:
       2015-04-23 at 2:11 am

       Hi Saif,

       I, too, need to run a Salesforce ID match, but didn't quite understand how to use that code to create a text string long enough for a 15 digit character.
       May I bother you to show me your formula?

       Thanks,
       Lynn

11. 

    Tim Murphy says:
    2014-11-03 at 6:11 pm

    Really helpful instructions for the case-sensitive vlookup. Thanks for sharing.