Lookup case sensitive match with EXACT function

Lookup case sensitive

There are many methods to lookup case sensitive match, but in this article we will discuss array function with INDEX MATCH with EXACT function. In the below table, same name Deep Singh is repeated with small case. If we apply Vlookup formula, in both cases it will return first match without considering the case sensitivity. … Read more