Feedback by UserVoice

 

How can we improve Excel for Windows (Desktop Application)?

← Excel for Windows (Desktop Application)

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.

12 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Mike Kruszynski shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

4 comments

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Ron commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    it is impossible to manipulate salesforce data using vlookup function. please fix!!!!!!!!!!!!!

  • JP commented  ·   ·  Flag as inappropriate

    Indeed, it will be very useful as I personal have faced lots of data issues in this.

Excel for Windows (Desktop Application): Formulas and Functions

Categories

Feedback and Knowledge Base

(thinking…)