Case sensitive lookups

Case sensitive lookups

12 September 2015

We all know that VLOOKUP (and its cousins MATCH, HLOOKUP and LOOKUP) are great for finding information you want. But they are helpless when you want to do a case-sensitive lookup.

So how do we write case sensitive VLOOKUP formulas? Simple. We can use EXACT formula.