All articles with 'EXACT()' Tag
![Case Sensitive Lookups](https://chandoo.org/wp/wp-content/uploads/2015/09/case-sensitive-vlookup-in-excel.png)
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.
Continue »