How to do case sensitive lookup

How to do case sensitive lookup

A case-sensitive lookup can be done using an array of functions like INDEX, MATCH, and EXACT. Always remember that you need to enter the formula with the array of functions using the Control + Shift +Enter. Note that the EXACT function will always return TRUE if there are two similar strings. The same function turns