How to do a case sensitive lookup in Excel
Most users know the VLOOKUP function is not that case-sensitive. For example, when you look up for DAN, dan, Dan to VLOOKUP, all this is the same. The function will return the first matching value regardless of its case. VLOOKUP Case sensitive functions. You can have a table like this; as you can see,