In this Excel lesson you will teach yourself how to create a case sensitive vlookup. This is a clever way to solve many problems caused by caps lock keyboard button.

Case-sensitive vlookup

Vlookup function doesn't care about case-sensitivity. So what to do when you do?

This is an example:

Case sensitive vlookup

The task is to vloookup the value to the word. Formula should care about case-sensitivity.

The solution is this array formula:


0 here means the exact match for the vlookup function.

Case sensitive vlookup formula

Formula in the example is:


Please be aware that it is an array formula so you need to use CTRL + SHIFT + ENTER keyboard shortcut. That's why there are braces around the formula. They appears after you typed CTRL + SHIFT + ENTER.

Case-sensitive lookup

The problem is that your data differ only by case so capitalization is important for you. That's why you need case sensitive lookup. Let's construct a formula which will solve your problem. INDEX formula suits the best. Syntax here will be:

=INDEX(value_you_need, row_number, column_number)

  • value_you_need is a data range from your data table
  • row_number - this is hard to get. You have to use EXACT function for case sensitive function
  • column_number is always 1

In this example you need the Price and you have Product IDs. The formula you need is:


case sensitive lookup