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.
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.
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.
it is impossible to manipulate salesforce data using vlookup function. please fix!!!!!!!!!!!!!
Indeed, it will be very useful as I personal have faced lots of data issues in this.