Case Sensitive VLOOKUP

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.

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:

=VLOOKUP(value,IF(EXACT(value,column),table),column_number,0)

0 here means the exact match for the vlookup function.

Case sensitive vlookup formula

Formula in the example is:

{=VLOOKUP($D2,IF(EXACT($D2,$A$2:$A$10),$A$2:$B$10),2;0)}

 

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.