We all know that
VLOOKUP (and its cousins
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
Full article: Case sensitive lookups