Hey All,


I am using the feature VLook Up to bring in Salesforce ID numbers to a spreadsheet but for some reason, the VLook Up function is ignoring the size of a letter that is lower case, instead of looking for the Uppercase letter.


Example:
On the Reference Sheet. (Used for the VLook Ups.

15 Character ID = 0061H00000iE0xB
18 Character ID = 0061H00000iE0xBQAS


When I do the VLook Up. I'm asking it to look at the 15 character ID on the load sheet and return me the 18 Character ID.


What is happening, is the VLook UP is stopping at the ID 0061H00000iE0xb and it brings back the 18 character ID for that record = 0061H00000iE0xbQAC


I don't understand why it has no problem with the lower case "i" or "x" in the 15 character ID but when it gets to the last character, which is an Upper Case "B", it takes the ID with the lower case "b" instead of looking further down the Reference sheet for the ID that has the Upper Case "B".


Sorry, I hope that makes sense.


Is there a setting or something I need to switch off or on?




Thank you,