Afternoon,
Thank you for getting back to me, much appreciated.
I always use "false" in the last box of the VLook Up, but what is "false/0"?
Here is an example of the issue...
I have Reference sheets from SFDC. The sheets have both the 15 character ID and the 18 character ID.
The 1st column is the 18 character ID.
The 2nd column is the 15 character ID.
The "case" of the letter B changed. The search results (the 18 character ID) should have been an Upper Case "B", instead I got the Lower Case "b", which is actually a different Opportunity in SFDC.
(See attachment below)
Basically, Excel is not looking for the EXACT match. It is ignoring Case, and stopping at the lower case "b" instead of searching further down the reference sheet for the ID with the Capital "B".
(See attachment below)
I hope that makes sense?
I just don't understand why Excel is ignoring letter Case (Capitals vs small).
My VLook Up setting look like this...
Thank you
Shawn Low