How to do a case sensitive lookup in Excel

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, … Read more