vlookup case sensitive
very simple,VLOOKUPs are case insensitive, VLOOKUPS should be case sensitive. One use case are Salesforce reports. They produce 15 character Ids that require case sensitivity functionality in order lookup against.

4 comments
-
Ron commented
You can build the EXACT() command into the VLookUp(), but it would be easier and more clear if it was included as an option.
.
Same for XLookup. I just tested, even in EXACT match it is not case sensitive. -
PN commented
By default, VLOOKUP isn't case-sensitive. VLOOKUP just returns the first match, ignoring whether the text is in upper or in lower case. Please add an option to the VLOOKUP function to make it consider case. Having VLOOKUP be able to perform a case-sensitive lookup would help a lot.
-
Becca commented
it is impossible to manipulate salesforce data using vlookup function. please fix!!!!!!!!!!!!!
-
JP commented
Indeed, it will be very useful as I personal have faced lots of data issues in this.