Case Sensitive Lookup in LibreOffice with Examples
In the prior articles, we have explained the concept of lookups with VLOOKUP, INDEX and MATCH. All of them together can be a great way to achieve several filtering results.
However, most of them are not case sensitive. That means if you search for lowercase data in cells, it searches for lowercase and uppercase.
Hence, it's important for you to learn the case sensitive lookups. Here's how.