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.

11 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
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 →

3 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • 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…)