i-nth logo
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.

Full article: Case sensitive lookups